不是這樣插入 是 insert b select 'a' union all select 'b' 將兩個select合并
insert b select '1','2' union all select '1','2' union all select '1','2' union all select '1','2'
谢谢,那insert能和update和在一起用union连起来吗? 例如我要往a插数据,更新b。
Insert Into Elements_40 Select (1,2) Union all Select (2,3) Union all Select (3,4) Union all Select (4,5) Union all Select (5,6) Union all Select (6,7) Union all Select (7,8)
是
insert b
select 'a'
union all
select 'b'
將兩個select合并
select '1','2'
union all
select '1','2'
union all
select '1','2'
union all
select '1','2'
例如我要往a插数据,更新b。
Insert Into Elements_40 Select (1,2) Union all Select (2,3) Union all Select (3,4) Union all Select (4,5) Union all Select (5,6) Union all Select (6,7) Union all Select (7,8)