How do I delete DUPLICATE ROWS from my MYSQL Database?
I have a large number of rows that have been duplicated. Obviously I only need 1 of each.
Example:
[RPO_CODES] [DESCRIPTION]
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
Z28 Performance Package
I want to do this simply with SQL Query. I was told DISTINT would work? Help. How.. Thanks.
MYSQL - Removing Duplicated Rows
Moderator: General Moderators
-
camarosource
- Forum Commoner
- Posts: 77
- Joined: Sat Aug 03, 2002 10:43 pm