1、复制表结构
create table table1 as select * from table2 where 1=2;
2、复制表结构及数据
create table table1 as select * from table2;
3、复制数据
insert into table1 select * from table2;
4、按字段复制
insert into table1(column1,column2) select column1,column2 from table2;