<delete id="deleteByMsgIds">
DELETE FROM message
WHERE msg_id in
<trim suffixOverrides=" OR id IN ()">
<foreach item="item" index="index" collection="list"
open="(" close=")">
<if test="index != 0">
<choose>
<when test="index % 1000 == 999">) OR id IN (</when>
<otherwise>,</otherwise>
</choose>
</if>
#{item}
</foreach>
</trim>
</delete>
mybatis in超过1000报错解决方案
最新推荐文章于 2024-05-27 15:20:32 发布