[size=medium]1.只复制表结构不复制表数据:
CREATE TABLE tab_new AS SELECT * FROM tab_old WHERE 1=2;
2.不复制表结构,只复制表数据的sql语句:
insert into tab_new select * from tab_old
3.既复制表结构,又复制表内容的sql语句:
CREATE TABLE tab_new AS SELECT * FROM tab_old;[/size]
CREATE TABLE tab_new AS SELECT * FROM tab_old WHERE 1=2;
2.不复制表结构,只复制表数据的sql语句:
insert into tab_new select * from tab_old
3.既复制表结构,又复制表内容的sql语句:
CREATE TABLE tab_new AS SELECT * FROM tab_old;[/size]