UPDATE table_name SET
username =
<foreach collection="list" index="index" item="item" separator=" " open="case id" close="end">
when #{item.id} then #{item.username}
</foreach>
,name =
<foreach collection="list" index="index" item="item" separator=" " open="case id" close="end">
when #{item.id} then #{item.name}
</foreach>
,age =
<foreach collection="list" index="index" item="item" separator=" " open="case id" close="end">
when #{item.id} then #{item.age}
</foreach>
WHERE id IN(
<foreach collection="list" item="item" index="index" separator=",">
#{item.id}
</foreach>)
mysql批量更新多个字段
最新推荐文章于 2024-04-08 19:16:39 发布