MYSQL之批量删除(mybatis)
如果参数是array数组
<update id="deleteAll"> delete from C_V WHERE UUID in <foreach item="item" index="index" collection="array" open="(" separator="," close=")"> #{item} </foreach> <include refid="where_appCode"/> </update>
如果参数是对象属性
<update id="deleteAll"> delete from C_V WHERE UUID in <foreach item="item" index="index" collection="code" open="(" separator="," close=")"> #{item} </foreach> <include refid="where_appCode"/> </update>
白茶清欢无别事,我在等风也等你,苦酒折柳今相离,无风无月也无你。