How to remove duplicate entries from a mysql db?

by

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.)

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 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. In MySQL, can I copy one row to insert into the same table?
  9. Removing duplicates with unique index
  10. How to delete duplicate rows from a MySQL table
  11. How do I delete all the duplicate records in a MySQL table without temp tables
  12. MySQL delete duplicate records but keep latest
  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. 1064 error in CREATE TABLE … TYPE=MYISAM
  17. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  18. How to use LOAD_FILE to load a file into a MySQL blob?
  19. Determine Rank based on Multiple Columns in MySQL
  20. Relational database design multiple user types
  21. Checking multiple columns for one value
  22. What is better in MYSQL count(*) or count(1)?
  23. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  24. How do I repair an InnoDB table?
  25. How to enable INNODB in mysql
  26. Calculate distance given 2 points, latitude and longitude [duplicate]
  27. How to write a (MySQL) “LIMIT” in SQL Server?
  28. Syntax error on MERGE statement
  29. MySQL: set field default value to other column
  30. Deleting a row based on the max value

Leave a Comment