Outside the Cube (8652)
Web publishing (65)
New related comments
Number of comments in the last 48 hours
How to run a *.sql script (mysql)
Remove duplicate rows from a table - independent from indexes
12 comments. Current rating: (6 votes). Leave comments and/ or rate it.
Question:I need to remove duplicate rows from my table. It has an autoincrement integer as primary key and a few other attributes (PROD_ID, RESOURCE_ID, DATE_ADDED). What's the easiest way to do that?
Answer:Follow these steps: