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

参考：http://www.runoob.com/sql/sql-insert-into-select.html