Remove redundant records in MySQL

Question

I've a table without PK and auto increment columns, I have same rows at mulitple times inserts. I wanna keep only one row and to remove other rows.

I have found more than 2000 rows matching the redundancy, how can I eliminate the duplicates.

See this [very similar question](http://stackoverflow.com/questions/37839651/mysql-delete-rows-where-dates-are-not-the-newest) asked minutes ago — AgRizzo, Jun 15 '16 at 15:39

score -2 · Answer 1 · edited May 23 '17 at 11:58

-2

Add an auto-incrementing ID to your table:

Then find your duplicates and delete them by their IDs.

edited May 23 '17 at 11:58

Community

answered Jun 15 '16 at 15:43

Zach Dennis

This got voted down because someone thinks this is not an acceptable way to remove duplicates or because the question was poor and I shouldn't have answered it? – Zach Dennis Jun 17 '16 at 16:03

1 Answers1