Jump to content

Archived

This topic is now archived and is closed to further replies.

curtis_b

load data local infile

Recommended Posts

I have been struggling with this command for months. I am following the mysql manual for my version on this one, and I can't get it to work. Any help would be greatly appreciated.

for importing a CSV file: "that","looks","like","this"

====

Being sent from the query sender in phpmyadmin:

load data local infile 'd:\home\sites\something.com\wwwroot\fmp_mysql\item_list.csv' into table item_list fields terminated by ',' enclosed by ' " '

====

MySQL said: Documentation
#1083 - Field separator argument is not what is expected. Check the manual

====
Manual says:

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name,...)]

====

Eventually this will be put in a php script, but I'm just trying to get the query right for now. Thanks

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.