mysql去重

DELETE FROM t_account_center WHERE USERNAME IN(
    SELECT t.USERNAME FROM(
        SELECT USERNAME FROM t_account_center GROUP BY USERNAME HAVING COUNT(*)>1
    ) t
)AND id NOT IN(
    SELECT t.id FROM(
        SELECT MAX(id) AS id FROM t_account_center GROUP BY USERNAME HAVING COUNT(*)>1
    ) t
)

DELETE FROM t_user WHERE PHONE IN(
    SELECT t.PHONE FROM(
        SELECT PHONE FROM t_user GROUP BY PHONE HAVING COUNT(*)>1
    ) t
)AND id NOT IN(
    SELECT t.id FROM(
        SELECT MAX(id) AS id FROM t_user GROUP BY PHONE HAVING COUNT(*)>1
    ) t
)