Hi guys,
I set up a table that I'll be using for a mailing list. Two
fields: id and addr. The id is a unique primary key that
is used to "identify" (?) the email address in the addr
field.
How can I remove duplicate addresses in the addr field?
I know of the
select distinct addr from tablename outfile filename.txt
But how can I write the data to another table or even
replace the information in the table with the output info?
And also, if I assign a UNIQUE key to the addr field, why
does it allow duplicates to begin with?
Pretty new to MySQL so please forgive my stupidity. :)
-Scott
http://www.scottscomputing.com
[EMAIL PROTECTED]
Get your own online Christian book store!
http://www.family-moment.com/cgi-bin/view.cgi/sw520122
---------------------------------------------------------------------
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
