WHERE xsfnsrsbh IN <foreach collection="param.nsrsbhList" index="index" item="nsrsbh" open="(" close=")"> <if test="index >0 "> <choose> <when test="(index % 1000) == 999"> ) or xsfnsrsbh in ( </when> <otherwise>,</otherwise> </choose> </if> #{nsrsbh} </foreach>
标签:xsfnsrsbh,nsrsbh,mysql,大于,WHERE,1000 From: https://www.cnblogs.com/yshyee/p/17812405.html