此处拼装批量插入语句。
mysql
insert into demo (id, name)
select '11','22' union
select '33','44'
oracle
insert into demo (id, name)
select '11', '22' from dual union all
select '33', '44' from dual
demo:表明
id,name 字段
你懂得
此处拼装批量插入语句。
mysql
insert into demo (id, name)
select '11','22' union
select '33','44'
oracle
insert into demo (id, name)
select '11', '22' from dual union all
select '33', '44' from dual
demo:表明
id,name 字段
你懂得
转载于:https://my.oschina.net/u/2764409/blog/715787