insert into student(age, name)
values
<foreachcollection="list"item="entity"separator=",">
(#{entity.age}, #{entity.name})
</foreach>
批量删除
<-只支持mysql>
delete from student
where (age,name) in
<foreachitem="entity"collection="list"separator=","open="("close=")">
(#{entity.age},#{entity.name})
</foreach><-支持sharding-sphere的批量删除><deleteid="deleteTest"><foreachitem="item"collection="list"separator=";">
delete student
where age = #{item.age} and name = #{item.name}
</foreach></delete>