ok, so I have a file full of email addresses. There's literally one address per line. Thats it. No delimiters, no other punctuation, nothing.
I need to get it into mysql and have absolutely no idea how to do it. Seriously, this is the layout of the file...
email@emailaddress1.com
email@emailaddress2.com
email@emailaddress3.com
email@emailaddress4.com
etc, etc....
phpmyadmin wont let me import it, says there's an invalid field count in the first line (where there's an email address).
Any ideas guys? I'll take anything at this point....
mysql import problems...
Moderator: General Moderators
-
silent assassin
- Forum Newbie
- Posts: 13
- Joined: Mon Feb 27, 2006 6:53 pm
The reason phpmyadmin won't import it is because your table prob. has a int primary key. (Which is good)
Try importing it with a unique number and a comma
Try importing it with a unique number and a comma
Code: Select all
1,email@emailaddress1.com
2,email@emailaddress2.com
3,email@emailaddress3.com
4,email@emailaddress4.com