I have a .txt file (ANSI) full of emails that I want to add to a table in my db. All the emails are on their own line and they end with a ';' . Is there an easy way to import this w/o manually doing each one?
Assuming you are using MySQL, you can do something like the following:
LOAD DATA local infile '/path/to/your/file.txt' into table TABLE_NAME fields terminated by ';'
That should work.
-- Jason
