复制到新表
create table 新表名称 as select * from 源表名称;
--复制部分数据的话后面加where条件
create table table2 as select * from table1 where name='test';
--备份表结构
create table table2 as select * from table1 where 1=2;
复制已存在的表
insert into 目标表 select * from 源表;
--示例
insert into table2 select * from table1 where name='test';