How to delete duplicates on a MySQL table?

by

This removes duplicates in place, without making a new table.

ALTER IGNORE TABLE `table_name` ADD UNIQUE (title, SID)

Note: This only works well if index fits in memory.

More Related Contents:

  1. Remove duplicate rows in MySQL
  2. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  3. Find duplicate records in MySQL
  4. How to abort INSERT operation in MySql trigger?
  5. Prevent auto increment on MySQL duplicate insert
  6. Deleting duplicate rows from a table
  7. In MySQL, can I copy one row to insert into the same table?
  8. Removing duplicates with unique index
  9. How to delete duplicate rows from a MySQL table
  10. How do I delete all the duplicate records in a MySQL table without temp tables
  11. MySQL delete duplicate records but keep latest
  12. How to remove duplicate entries from a mysql db?
  13. Count duplicates records in Mysql table?
  14. How to do unique constraint works with NULL value in MySQL
  15. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  16. MySQL – Rows to Columns
  17. ROW_NUMBER() in MySQL
  18. Join tables with SUM issue in MYSQL
  19. sql joins as venn diagram
  20. How can I join multiple SQL tables using the IDs?
  21. How to perform a mysqldump without a password prompt?
  22. MySQL, better to insert NULL or empty string?
  23. MySQL indexes – what are the best practices?
  24. Selecting random rows with MySQL
  25. Is there a naming convention for MySQL?
  26. Why does MySQL autoincrement increase on failed inserts?
  27. error code 1292 incorrect date value mysql
  28. How to search for rows containing a substring?
  29. Should I always prefer MySQL InnoDB over MyISAM?
  30. MySQL add 12 hours to a time field

Leave a Comment