摘要：insert into table1 select * from table2 --表结构相同 表结构不同或跨数据库时insert into table1 (field1,field2,field3) select （table2.field1,table2.field2.table2.field3 阅读全文