bingo

删除表中多余的重复记录（多个字段），只留有rowid最小的记录delete from 表 a where (a.Id,a.seq) in (select Id,seq from 表 group by Id,seq having count(*) > 1) and rowid not in (select min(rowid) from 表 group by Id,seq having c...

1、插入（1）第一种方式：利用<foreach>标签，将入<insert id="insertBatchLaTContactRecord" parameterType="java.util.Map"> <selectKey resultType="java.lang.Long" keyProperty="dto.id" order="BEFORE">...