MySQL数据去重

把IP和Email相同的记录删掉

第一步：

SELECT * FROM test_delete
WHERE IP IN (SELECT IP FROM test_delete GROUP BY IP HAVING COUNT(IP)>1)

第二步：

DELETE
FROM testdelete
WHERE IP IN(SELECT
               IP
             FROM (SELECT
                     IP
                   FROM testdelete
                   GROUP BY IP
                   HAVING COUNT(IP) > 1) a)
    AND id NOT IN(SELECT
                    *
                  FROM (SELECT
                          MIN(id)
                        FROM testdelete
                        GROUP BY IP
                        HAVING COUNT(IP) > 1) b)