SQL复制表的几种方法:
SQL复制整张表
select * into newtablename from oldablename
只复制列名而不要内容
select * into newtablename from oldablename where 1=0
表间数据复制
insert into table1(col1) select col2 from table2
SQL复制表的几种方法:
SQL复制整张表
select * into newtablename from oldablename
只复制列名而不要内容
select * into newtablename from oldablename where 1=0
表间数据复制
insert into table1(col1) select col2 from table2