Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing a .csv file utilizing phpMyAdmin

Status
Not open for further replies.

Tread42

MIS
Feb 5, 2002
151
US
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
 
for this the enclosed by is " (optionally uncecked) and fields ternminated by \n leav the lines terminated by blank. ***************************************
Party on, dudes!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top