1、sqlserver

原表存在:insert into a select * from b

原表不存在:select * into a from b

2、mysql、oracle

原表存在:insert into a select * from b

原表不存在:create table a select * from b