Hello,

Has anyone experienced and/or solved this problem on a Linux / Apache / MySQL system?

I'm trying to call mysqlimport remotely over CGI using perl's system command, to 
upload and import csv files. Basically everything works except for setting the 
'--fields-optionally-enclosed-by' argument, which I want to set to " (doublequote), as 
Excel puts them round any field containing a comma.

The full command is:

mysqlimport --verbose --fields-terminated-by=, --fields-optionally-enclosed-by='"' 
mydb myfilename

It just gives up after the first row with a comma in it, after trying to put the whole 
of the remainder of the csv file into the one field. Any ideas?

Thanks in advance,

Vyv Hope-Scott
377a St Margarets Rd
Twickenham TW1 1PP
h 020 8744 2488
m 07768 660 247

Reply via email to