UPDATE version oi INNER JOIN ( <trim suffixOverrides="UNION ALL"> <foreach collection="list" item="item" index="index"> SELECT #{item.version} version, #{item.id} id FROM DUAL UNION ALL </foreach> </trim> ) du ON du.id = oi.id SET oi.version = du.version
mybatis 批量修改
最新推荐文章于 2024-05-21 18:07:54 发布