title: Remove redundant records in MySQL
body: <p>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.</p>
  
  <p>I have found more than 2000 rows matching the redundancy, how can I eliminate the duplicates.</p>