MySQL find and delete duplicate rows keeping the lowest id

-- Preview duplicates
SELECT email, COUNT(*) AS total
FROM users
GROUP BY email
HAVING COUNT(*) > 1;

-- Delete duplicates, keep the lowest id
DELETE u1
FROM users u1
JOIN users u2
  ON u1.email = u2.email
 AND u1.id > u2.id;

#mysql #duplicates #delete #cleanup #self-join