CREATE TEMPORARY TABLE tmp AS SELECT MIN(id) FROM 待删除数据表名 GROUP BY 唯一字段1,唯一字段2
SELECT * FROM tmp
DELETE FROM 待删除数据表名 WHERE id NOT IN(SELECT * FROM tmp)
CREATE TEMPORARY TABLE tmp AS SELECT MIN(id) FROM 待删除数据表名 GROUP BY 唯一字段1,唯一字段2
SELECT * FROM tmp
DELETE FROM 待删除数据表名 WHERE id NOT IN(SELECT * FROM tmp)