[thelist] MySQL - load data infile - fields escaped by
Joel Canfield
joel at spinhead.com
Sat Jul 20 16:18:01 CDT 2002
--
[ Picked text/plain from multipart/alternative ]
When I try this
mysql> load data infile 'phpupload_20020720.txt'
-> fields escaped by '\\'
-> fields optionally enclosed by '\"'
-> fields terminated by ','
-> lines terminated by '\n'
-> ;
I get the error
ERROR 1064: You have an error in your SQL syntax near 'fields escaped by
'\\'
fields optionally enclosed by '\"'
fields terminated by '' at line 2
I've tried with double quotes, I've tried *not* escaping the backslash. What
is the syntax for defining the escape character?
Thanks so much.
joel
More information about the thelist
mailing list