Page 1 of 1

MYSQL - Removing Duplicated Rows

Posted: Thu Oct 04, 2007 1:50 am
by camarosource
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.

Posted: Thu Oct 04, 2007 2:06 am
by VladSun