List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:March 19 2003 10:26pm
Subject:Re: How to find duplicates?
View as plain text  
At 23:09 +0100 3/19/03, Ignatius Reilly wrote:
>You can not selectively delete only one of two duplicates in SQL.

You can, actually.  If you know you have two records, for example,
you can add LIMIT 1 to the end of the DELETE statement that identifies
both of them.

Paul DuBois
sql, query
How to find duplicates?AldrinSE Magnus Aldrin19 Mar
  • Re: How to find duplicates?Ignatius Reilly19 Mar
    • Re: How to find duplicates?Paul DuBois19 Mar
Re: How to find duplicates?webmaster20 Mar
Re: How to find duplicates?rob spijkerman20 Mar