delete tt from testuser tt INNER JOIN ( select id1 FROM
(
SELECT
t.id id1, t2.id id2, count(t.id) cnt
FROM
testuser t,
testuser t2
WHERE
t.`name` = t2.`name`
AND t.idcard = t2.idcard
GROUP BY
t.id
) t_out where cnt > 1 and instr(id1, id2) > 0 ) t11 on tt.id = t11.id1
测试表字段 : id idcard name,
去重规则,idcard 和 name相同则记录重复