[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