将查询结果插入到新表

sql server 

-- 将查询 select * from user1 的结果插入到新表user2
select * 
into user2
from user1;

mysql 

create table user2 (select * from user1);