INSERT: 批量插入結果集 1. insert into table select x,y from A UNION select z,k from B ; 2. insert into table select x,y,z from A where 1=1; 3.批量導入表數據 ，不導入表約束 ...
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;
