List:General Discussion« Previous MessageNext Message »
From:SGreen Date:March 31 2006 1:08pm
Subject:Re: Delete Duplicates
View as plain text  
Rich <lists@stripped> wrote on 03/30/2006 09:11:56 PM:

> Hi there.  Any quick way of killing duplicate records?
> Cheers

Yes. Some ways involve subqueries, others temporary tables. What version 
are you on? What are your table definition(s) (use SHOW CREATE TABLE to 
dump the defs)? How do your define "duplicate" for the table(s) you are 
having problems with?

More details will get you better answers ;-)

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Delete DuplicatesRich31 Mar
  • Re: Delete DuplicatesBarry31 Mar
  • Re: Delete DuplicatesPrasanna Raj31 Mar
  • Re: Delete DuplicatesSGreen31 Mar