How to remove duplicate entries from a mysql db?

This command adds a unique key, and drops all rows that generate errors (due to the unique key). This removes duplicates.

ALTER IGNORE TABLE table ADD UNIQUE KEY idx1(title);

Edit: Note that this command may not work for InnoDB tables for some versions of MySQL. See this post for a workaround. (Thanks to “an anonymous user” for this information.)

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 delete duplicates on a MySQL table?
  5. How to abort INSERT operation in MySql trigger?
  6. Prevent auto increment on MySQL duplicate insert
  7. Deleting duplicate rows from a table
  8. MySQL delete duplicate records but keep latest
  9. How do I delete all the duplicate records in a MySQL table without temp tables
  10. In MySQL, can I copy one row to insert into the same table?
  11. Removing duplicates with unique index
  12. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  13. How to delete duplicate rows from a MySQL table
  14. How can I search (case-insensitive) in a column using LIKE wildcard?
  15. How to find similar results and sort by similarity?
  16. Using variable in a LIMIT clause in MySQL
  17. mysql select dynamic row values as column names, another column as value
  18. MySQL Split Comma Separated String Into Temp Table
  19. SQL Performance UNION vs OR
  20. Mysql order by specific ID values
  21. Is the primary key automatically indexed in MySQL?
  22. MySQL autoincrement column jumps by 10- why?
  23. MySQL: Fastest way to count number of rows
  24. How to export SQL Server database to MySQL? [duplicate]
  25. ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
  26. MySQL user DB does not have password columns – Installing MySQL on OSX
  27. MySQL – length() vs char_length()
  28. Mysql string split [duplicate]
  29. What are the differences between utf8_general_ci and utf8_unicode_ci? [duplicate]
  30. How to create relationships in MySQL
  31. Pass array to MySQL stored routine
  32. How do I use on delete cascade in mysql?
  33. How to get the next auto-increment id in mysql
  34. MySQL variable format for a “NOT IN” list of values
  35. How to subtract hours from a datetime in MySQL?
  36. Order by COUNT per value
  37. Why does MySQL autoincrement increase on failed inserts?
  38. What is the MySQL query equivalent of PHP strip_tags?
  39. MySQL Group By and Sum total value of other column
  40. Mysql Improve Search Performance with wildcards (%%)
  41. Facebook like notifications tracking (DB Design)
  42. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  43. How to set root password to null
  44. What is the best MySQL collation for German language
  45. Use Composite Primary Key as Foreign Key
  46. What resources exist for Database performance-tuning? [closed]
  47. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  48. Bind address and MySQL server [closed]
  49. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  50. How to drop all tables from the database with manage.py CLI in Django?

Leave a Comment