使用insert into select 语句
语句形式
insert into Table2(field1,field2,...) select value1,value2,... from Table1 [where column =value]
从一个数据库到另一个数据,语句修改为
insert into db2.Table2(field1,field2,...) select value1,value2,... from db1.Table1 [where column =value]