sql复制表和数据

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

SQL语句：CREATE TABLE tab_new AS SELECT * FROM kdpssys.tab_old;
SQL语句：CREATE TABLE tab_new AS SELECT * FROM tab_old WHERE 1=2;
sql语句：insert into tab_new select * from tab_old;或者SELECT vale1, value2 into Table2 from Table1

红色部分可以是orale的用户,就是从另一个库到另一个库