Jump to content

Archived

This topic is now archived and is closed to further replies.

ozfactor

MySQL dump data to

Recommended Posts

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!

Share this post


Link to post
Share on other sites

Hows your list of emails stored, in a plain text file? spreadsheet?

let me know and we can build a little script (and a sql table of course)...

Share this post


Link to post
Share on other sites

One thing u can do is

 

create a css (comma seprated value) file

 

which will conatain

 

email,header

 

and try this command

 

LOAD DATA INFILE [b]file_name[/b] INTO TABLE [b]TABLE_NAME[/b]  FIELDS TERMINATED BY \',\' LINES TERMINATED BY \'n\' 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.