RsD0p9BK
4/10/2015 - 10:26 AM

delete_duplicates.sql

-- Delete all Duplicate Rows except for One in MySQL

DELETE n1 FROM names n1, names n2 WHERE n1.id > n2.id AND n1.name = n2.name;
-- OR --
DELETE n1 FROM names n1, names n2 WHERE n1.id < n2.id AND n1.name = n2.name;

-- http://stackoverflow.com/questions/4685173/delete-all-duplicate-rows-except-for-one-in-mysql