1.复制表
create table dxxx as select * from zhzs_ahqscjdj_dxxx
或 create table dxxx1 as select * from zhzs_ahqscjdj_dxxx where 1=1 2.复制表结构 create table dxxx2 as select * from zhzs_ahqscjdj_dxxx where 1=01.复制表
create table dxxx as select * from zhzs_ahqscjdj_dxxx
或 create table dxxx1 as select * from zhzs_ahqscjdj_dxxx where 1=1 2.复制表结构 create table dxxx2 as select * from zhzs_ahqscjdj_dxxx where 1=0