On gists

MySQL - Remove duplicate entries

MySql MySql - advanced

remove.sql Raw #

DELETE FROM your_table
WHERE rowid NOT IN (
    SELECT MAX(rowid)
    FROM your_table
    GROUP BY column1, column2, ...
);