INSERT INTO with CSV file

[Yrogerg]

I have a CSV file full of email addresses for an online newsletter that I need to insert into a new MySQL database. Is there a way to import the CSV file or do I have to manually enter each email address?

The table in the db has 2 fields, id and email. All I need is to insert all the emails from the CSV file into it.

[MrAlaska]

Yup, you can do dat.

If the data matches your table it is rather simple. If you have file permissions you can supply the virtual path instead of the local one. It happens in a heartbeat, the data is loaded immediately.

load data local infile '/home/sites/siteno/web/sever/local/path/file.txt' into table TableName fields terminated by ',';

Or something like that. If you run into trouble, the documentation lays it out pretty well:

http://www.mysql.com/doc/en/LOAD_DATA.html