MYSQL - Removing Duplicated Rows

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
camarosource
Forum Commoner
Posts: 77
Joined: Sat Aug 03, 2002 10:43 pm

MYSQL - Removing Duplicated Rows

Post 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.
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Post by VladSun »

There are 10 types of people in this world, those who understand binary and those who don't
Post Reply