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
2023-07-24 15:06:16
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