<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>