SV: Finding Duplicates and Deleting

2001-02-09 Thread Jacob Kamp Hansen
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

Re: Finding Duplicates and Deleting

2001-02-08 Thread Steve Ruby
"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

Re: Finding Duplicates and Deleting

2001-02-08 Thread Rus
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 ---

Re: Finding Duplicates and Deleting

2001-02-08 Thread Anna
>- 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 --

RE: Finding Duplicates and Deleting

2001-02-08 Thread Carsten H. Pedersen
> 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

Finding Duplicates and Deleting

2001-02-08 Thread 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