how to find double

2002-09-06 Thread Keith Burke [Experience IT]
and * * ** -Original Message- From: jf Leoni [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 11:28 To: [EMAIL PROTECTED] Subject: how to find double hello, i have a table with 10 500 000 rows on a mysql datab

how to find double

2002-09-06 Thread jf Leoni
hello, i have a table with 10 500 000 rows on a mysql database how can i find doubles ?? i know how to do it using php, but maybe there is a way using only queries? tks JF leoni - Before posting, please check: http://ww

RE: find double

2002-01-18 Thread Achim, Caterina
you should make a self-join to find the duplicates in one table. -Original Message- From: Jean Fabrice Leoni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 2:00 PM To: [EMAIL PROTECTED] Subject: find double hi, i have a mysql table with 10 millions rows. Response time is

find double

2002-01-18 Thread Jean Fabrice Leoni
hi, i have a mysql table with 10 millions rows. Response time is perfect, but i have some duplicated entries inside ... (maybe 100 - 200 rows) how can i find them using only SQL ? i can do it with php but really don't know if it is possible using only a SQL query ... best regards. Jean-Fabri