1.复制表结构
SELECT vale1, value2 into Table2 from Table1
create table b as select * from a where 1<>1
create table b as select * from a
create table b as select row_id,name,age from a where 1<>1
create table b as select row_id,name,age from a
Insert into Table2(field1,field2) select value1,value2 from Table1
SELECT vale1, value2 into Table2 from Table1