17,377
社区成员
发帖
与我相关
我的任务
分享
create table temptable as select colum1,colum2,colum3,colum4,colum5,colum6,colum7 from tablename
--可以把tableB当作临时表,create创建,drop删除;可以根据需要修改 where ... and other_condition :
--只导瓜皮不导瓜瓤(只导表结构不导数据)的语句:
create table tableB as (select * from tableA where 1=0);
--既导瓜皮又导瓜瓤的语句:
create table tableB as (select * from tableA where 1=1);
--> Test Data: [T]