1.只复制原表的结构:
create table newTable as select * from oldTable where 1=2;
2.复制原表的结构并且数据也拿过来:
create table newTable as select * from oldTable where 1=1;
1.只复制原表的结构:
create table newTable as select * from oldTable where 1=2;
2.复制原表的结构并且数据也拿过来:
create table newTable as select * from oldTable where 1=1;