1. 復(fù)制表結(jié)構(gòu)及其數(shù)據(jù)：
create table table_name_new as select * from table_name_old
2. 只復(fù)制表結(jié)構(gòu)：
create table table_name_new as select * from table_name_old where 1=2;
或者：
create table table_name_new like table_name_old
3. 只復(fù)制表數(shù)據(jù)：
如果兩個(gè)表結(jié)構(gòu)一樣：
insert into table_name_new select * from table_name_old
如果兩個(gè)表結(jié)構(gòu)不一樣：
insert into table_name_new(column1,column2...) select column1,column2... from table_name_old
Ref:http://www.cnblogs.com/youxinqiang/archive/2008/12/26/1363030.html