把查询的结果保存到新表中

insert into newtablename select * from tablename;　

如果表不存在

creat table newtablename as select * from tablename;