| 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 http://www.kitebird.com/ sql, query
| Thread | ||
|---|---|---|
| • How to find duplicates? | AldrinSE Magnus Aldrin | 19 Mar |
| • Re: How to find duplicates? | Ignatius Reilly | 19 Mar |
| • Re: How to find duplicates? | Paul DuBois | 19 Mar |
| • Re: How to find duplicates? | webmaster | 20 Mar |
| • Re: How to find duplicates? | rob spijkerman | 20 Mar |