ind of bad example, but you should get the idea) Then delete
records from the table where found is more than one.
/Jacob
-Oprindelig meddelelse-
Fra: Linsen Limsico [mailto:[EMAIL PROTECTED]]
Sendt: 8. februar 2001 18:13
Til: mysql_list
Emne: Finding Duplicates and Deleting
Does anyone know h
"Carsten H. Pedersen" wrote:
>
> > Does anyone know how to find duplicates in a table and deleting
> > them. I can't figure out how to structure the query.
> >
> > Linsen
>
> http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_6_0
>
> / Carsten
> --
> Carsten H. Pedersen
> keeper and maintainer of t
To: mysql_list <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 8:13 PM
Subject: Finding Duplicates and Deleting
Does anyone know how to find duplicates in a table and deleting them. I
can't figure out how to structure the query.
Linsen
---
>- Original Message -
>From: "Linsen Limsico"
>Does anyone know how to find duplicates in a table and >deleting them. I
can't figure out how to structure the query.
>Linsen
Exact duplicates or where only one field is duplicated?
Anna
--
> Does anyone know how to find duplicates in a table and deleting
> them. I can't figure out how to structure the query.
>
> Linsen
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_6_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlf
Does anyone know how to find duplicates in a table and deleting them. I can't figure
out how to structure the query.
Linsen