INSERT: 批量插入结果集方式
INSERT: 批量插入结果集
- insert into table
select x,y from A
UNION select z,k from B ; - insert into table
select x,y,z from A where 1=1;
3.批量导入表数据 ,不导入表约束
select x,y,z into B from A where 1=1;
posted on 2019-08-28 15:59 HeavenTang 阅读(981) 评论(0) 编辑 收藏 举报