curtis_b Posted March 2, 2006 Share Posted March 2, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/3924-load-data-local-infile/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.