仅复制表结构
create table newTb as select * from oldTb where 1=0;
复制结构和全部数据
create table newTb as select * from oldTb;
复制结构和部分数据
create table newTb as select * from oldTb where a =***** and b=***;
仅复制表结构
create table newTb as select * from oldTb where 1=0;
复制结构和全部数据
create table newTb as select * from oldTb;
复制结构和部分数据
create table newTb as select * from oldTb where a =***** and b=***;