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
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
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
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