mybatis 多条件批量删除整理

https://blog.csdn.net/ZYC88888/article/details/88534807

mybatis 多条件批量删除整理

ZhaoYingChao88 2019-03-13 16:07:16 11999 收藏 21
分类专栏： mysql 文章标签： mysql
版权

批量增加

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 id="deleteByLogic"  parameterType = "java.util.List"><br />     delete from user where id > 2000<br />         or id in<br />      <foreach collection="list"  item="item" open="(" separator="," close=")"  ><br />           #{item}<br />      </foreach><br /></delete><br />  复杂条件批量删除 建议增加联合索引
<!--通过条件删除数据--><br />    <delete id="batchDeleteByCondition"><br />        delete from test where<br />        <foreach collection="list" item="item" separator=" or " index="index"><br />            (name = #{item.name} and area_code = #{item.areaCode} and type = #{item.type})<br />        </foreach><br />    </delete><br /> 复杂条件批量删除 IN操作

delete from test
where (PRSNLID, ENTID) in

(#{item.prsnlid},#{item.entid})

mybatis 多条件 批量删除整理