mybatis多条件批量删除整理
批量增加 insert into t_user (user_name,sex) values (#{u.userName},#{u.sex}) 批量删除 delete from t_user where id in ( #{id} ) delete from t_user where id in #{id} 复杂条件批量删除 delete from user where id > 2000 or id in #{item} 复杂条件批量删除 建议增加联合索引 delete from test where (name = #{item.name} and area_code = #{item.areaCode} and type = #{item.type}) 复杂条件批量删除 IN操作 delete from test where (PRSNLID, ENTID) in (#{item.prsnlid},#{item.entid}) ———————————————— https://blog.csdn.net/ZYC88888/article/details/88534807