1、既复制表结构也复制表内容的SQL语句:CREATE TABLE table_new AS SELECT * FROM table_old;
2、只复制表结构不复制表内容的SQL语句:CREATE TABLE table_new AS SELECT * FROM table_old WHERE 1=2;
3、不复制表结构,只复制内容的sql语句:insert into table_new select * from table_old;或者SELECT vale1, value2 into Table2 from Table1