> *****
> NAME EMAIL AGE
> tom tom@mail 23
> dick tom@mail 76
> pete pete@email 54
> dave cool@mail 21
> steve steve@mail 17
> mary cool@mail 89
> thomas tom@mail 13
> rich rich@mail 65
> rich dick@mail 33
> tom tom@mail 23
> tom tom@mail 23
> so what i want to do is cut it down so there are no duplicate email
> addresses. I want the table looking like this:
> *****
> NAME EMAIL AGE
> tom tom@mail 23
> pete pete@email 54
> dave cool@mail 21
> steve steve@mail 17
> rich rich@mail 65
> rich dick@mail 33
I would create a new table with unique index on the pair name,
email. Then import all records into that table. Redundancies will
be avoided by your index. Kill the old table, rename the new
table.
--
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
