mysql INSERT INTO table2 (column_name(s)) SELECT column_name(s) FROM table1;

INSERT INTO cy_business (id, gamename, created_at) SELECT id, name, create_time FROM cy_game where id=396

#        
INSERT INTO cy_game_agent_point(game_id,agent,point,created_user,created_at)
SELECT
	t2.*, agent,point,'sys',unix_timestamp(now())
FROM
cy_ct_cps_user t1
INNER JOIN (
	SELECT
		id gameid
	FROM
		cy_game
	WHERE
	id in (189,307,423,444,486,487,488,489,490,493,505)
) t2 WHERE (t1.agent IS NOT null && t1.agent != '') and t1.point !=0 and point<=60;

INSERT INTO cy_pay_ok (orderid,amount,username,small_username,roleid,paytype,serverid,servername,gameid,gamename,ip,imeil,create_time,agent,regagent,agent_username,prvite,second_agent,second_username,one_agent,one_username,type,attach)  -- SELECT orderid, amount, username,small_username,roleid,paytype,serverid,servername,gameid,gamename,ip,imeil,create_time,agent,regagent,agent_username,prvite,second_agent,second_username,one_agent,one_username,0,attach FROM cy_pay where status=1 and username='chenyu0203' and gameid=838 and orderid!=15484268601643
参照先:http://www.runoob.com/sql/sql-insert-into-select.html