mybatis和mysql批量添加和删除和sharding-sphere批量删除

批量添加

insert into student(age, name)
values
<foreach collection="list" item="entity" separator=",">
    (#{entity.age}, #{entity.name})
</foreach>

批量删除

<-只支持mysql>
delete from student
where (age,name) in
<foreach item="entity" collection="list" separator="," open="(" close=")">
    (#{entity.age},#{entity.name})
</foreach>

<-支持sharding-sphere的批量删除>
<delete id="deleteTest">
    <foreach item="item" collection="list" separator=";">
        delete student
        where age = #{item.age} and name = #{item.name}
    </foreach>
</delete>