1 复制表结构及数据到一个新表:create table thenewtablename select * from theoldtablename;
2 只复制表结构到新表:create table newtablename select * from oldtablename where 1==2;
或者 create table newtable like oldtable;
3 复制旧表的数据到新表(假设两个表结构一样):insert into newtable select * from oldtable;
4 复制旧表的数据到新表(假设两个表结构不一样):insert into newtablename(p1,p2,p3...) select p11,p12,p13... from oldtablename;