有tattle1,table2两张表结构完全一样

有tattle1,table2两张表结构完全一样,写一条sql,把table1中的数据插入他table2中

insert into table2 select * from table1;

insert into table2 values (select * from table1);

把table2删了 create table2 like table1 就ok

insert into table2 select * from table1;这样就可以了！

insert into table2 values (select * from table1)