How to remove duplicate entries from a mysql db?
Posted
by Yegor
on Stack Overflow
See other posts from Stack Overflow
or by Yegor
Published on 2010-05-19T16:35:17Z
Indexed on
2010/05/19
16:40 UTC
Read the original article
Hit count: 132
mysql
|remove-duplicates
I have a table with some ids + titles. I want to make the title column unique, but it has over 600k records already, some of which are duplicates (sometimes several dozen times over).
How do I remove all duplicates, except one, so I can add a UNIQUE key to the title column after?
© Stack Overflow or respective owner