1、复制表结构
select [col1,col2,col3...] into new_table
from old_table where 1=1 ;
2、复制数据
insert into table1(col1,col2,col3,...)
select [col1,col2,col3...] from table2 ;
1、复制表结构
select [col1,col2,col3...] into new_table
from old_table where 1=1 ;
2、复制数据
insert into table1(col1,col2,col3,...)
select [col1,col2,col3...] from table2 ;