mysql INSERT INTO table2 (column_name(s)) SELECT column

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