将查询的数据添加创建的新表

create table tablename as select * from table;

如果表名存在

insert into table as select * from table;