Jump to content


Photo

load data local infile


  • Please log in to reply
No replies to this topic

#1 curtis_b

curtis_b
  • Members
  • PipPipPip
  • Advanced Member
  • 48 posts

Posted 02 March 2006 - 05:33 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users