Thank You so very much. Your way was great, fast and efficient. Here is
my line of code:
insert into sub2 (email,list_id) select email, list_id from subscribers;
Thanks Again
Steve Buehler
At 03:31 AM 8/14/2001, you wrote:
>I'd do it this way:
>
>insert into table table_new
> select from table_old
>
>(you work out the correct syntax)
>
>and define email in table_new as unique.
>
>This will insert the first record and produce errors on all
>duplicates. Then rename table_old to table_old_bak and table_new
>to table_old
>
>Steve Buehler schrieb am Montag, 13. August 2001, 22:30:20:
>
> > I hope that someone here can help me with a little problem. We have a
> > database that has a lot of duplicate entries in it for one of the fields
> > (email). I need to find a way to search the database, find all of the
> > duplicate entries and delete all but one of the entries. It would not be
> > practical to do it by me searching for dups of each email address
> > manually. It needs to do all of it by itself because we have over 3
> > million entries in the database. Does anybody know of any code that might
> > be able to help me out? I would really appreciate it. Please email me
> > directly as I am not receiving email from the list for some reason.
>
> > Thank You
> > Steve Buehler
>
>
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
>
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>--
>Herzlich
>Werner Stuerenburg
>
>_________________________________________________
>ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
>Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
>http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
