1、sqlserver
原表存在:insert into a select * from b
原表不存在:select * into a from b
2、mysql、oracle
原表不存在:create table a select * from b