一、批量插入
1.1、oracle批量插入
insert into test(name)
select * from
(select '111' from dual
union all select '222' from dual
union all select '333' from dual
union all select '444' from dual)
1.2、mysql批量插入
insert into test(name) values ('111'),('222'),('333'),('444');
二、批量更新
2.1、oracle批量更新
update test set salary = salary + 200 where dept_id = '10000' ;
2.2、mysql批量更新
#replace into更新以ID作为更新条件
replace into test(id,name) values ('1110','张三1'),('2220','李四1'),('3330','王五1');