Find and remove duplicates


How to find and remove duplicates.

Find and remove duplicates.


Select duplicates:


Remove duplicates with a DELETE statement:

Remove duplicates with a new unique key:


This ALTER TABLE with IGNORE keyword will create new unique key and remove all duplicates from the table in a one step.

Leave a Reply

Your email address will not be published. Required fields are marked *