ruby on rails - How to delete duplicate records in mysql database?

Question

What's the best way to delete duplicate records in a mysql database using rails or mysql queries?

Answer 1

What you can do is copy the distinct records into a new table by:

 select distinct * into NewTable from MyTable