import text file into mysql
Posted: Wed May 24, 2006 3:21 pm
I have a table in mysql with two columns: id , email.
I'm trying to import a text file (textedit on mac) with a list of email addresses using the import text file feature in phpmyadmin.
Nothing is working. I've tried many different combinations with ; , separation and stuff but no luck.
Can someone show me a basic text file with a few emails that will import to my table?
The id column is auto_increment.
Thanks
I'm trying to import a text file (textedit on mac) with a list of email addresses using the import text file feature in phpmyadmin.
Nothing is working. I've tried many different combinations with ; , separation and stuff but no luck.
Can someone show me a basic text file with a few emails that will import to my table?
The id column is auto_increment.
Thanks