<delete id="deleteAppUserByIds">
delete from app_userinfo where
<foreach item="item" index="key" collection="ids" open="" separator="," close="">
userid=#{item.userid} and appid=#{item.appid}
</foreach>
</delete>
原文：https://www.cnblogs.com/lykbk/p/dfdfedfdfdfdfdfd45454545454.html