I'm trying to import in a csv file to MySQL. There is only one field in this file but I can't find the delimeter using phpMyAdmin.
The field is layed out like this
"11111"
"22222"
"33333"
And such, how do I code in that the fields are delimeted by a "return"? Is there a special character reference? If it was a , it'd be easy enough to put that in the delimeter value but with a return it will not take it.
Thanks in advance for any help
Tread42
The field is layed out like this
"11111"
"22222"
"33333"
And such, how do I code in that the fields are delimeted by a "return"? Is there a special character reference? If it was a , it'd be easy enough to put that in the delimeter value but with a return it will not take it.
Thanks in advance for any help
Tread42