Mysql 删除重复数据

DELETE FROM 表名 WHERE id IN (
SELECT * FROM (
SELECT id FROM 表名 WHERE (name_add,address)
IN (
SELECT name_add,address FROM 表名 GROUP BY name_add,address HAVING COUNT(1) > 1
) AND id NOT IN (
SELECT MIN(id) FROM 表名 GROUP BY name_add,address HAVING COUNT(1) > 1
)
) AS stu_repeat_copy
);