#每天一个知识点# sql中批量更新的语句: 1 遍历更新,发送多条更新sql,虽然共用一个事务,但是依然性能较低. <update id="updateBatch"> <foreach separator=";" collection="list" item="c" index="index"> update t_user <set> status = 1 </set> where id = #{c} </foreach> </update> 2 使用case when,把所有情况列举,一个sql完成. 类似下面: UPDATE t_user SET path = CASE id WHEN '10800537' THEN '/api/ids/10800537' WHEN '10800118' THEN '/api/ids/10800118' END , address= CASE id WHEN '10800537' THEN '武汉' WHEN '10800118' THEN '上海' END WHERE id IN ('10800537','10800118')