ozfactor

I am trying to dump a list of email addresses into a mysql database called mail. The list is formatted like the following: email1@domain.com email2@domain.com How would I go about dumping this data to a \'sub_mail\' table with each email address auto incremented in the id field. Also I want the email field to hold the value of the emails and a field for header with a value of \'h\'? Thanks!

I have a mysql database I am trying to dump data into. I am trying to dump a list of email address into a mail database containing a sub_mail table. Each address will have a uniquie \'id\', an email value in the email field and an \'H\' in a header field. How would I go about first making sure there are no duplicates addies and then dumping this data. Gracias.