Deleting duplicates in MySQL table

queries.sql

SELECT field, COUNT(field) AS total FROM table GROUP BY field HAVING (COUNT(field) > 1)

DELETE t1 FROM table t1, table t2 WHERE t1.field = t2.field AND t1.id > t2.id

ALTER IGNORE TABLE table ADD UNIQUE INDEX(table)

DELETE t1 FROM table as t1, table as t2 WHERE t1.x = t2.x AND t1.y = t2.y AND t1.id > t2.id