[thelist] MySQL - load data infile - fields escaped by

Hassan Schroeder hassan at webtuitive.com
Sat Jul 20 16:27:01 CDT 2002


Joel Canfield wrote:

> When I try this
>
>   mysql> load data infile 'phpupload_20020720.txt'

You're missing the required\ INTO TABLE table_name \ here ...

>     -> 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
> '\\'

... and yeah, the error is /near/ there :-)

--
H*
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

     -- creating dynamic Web sites and applications since 1994 --





More information about the thelist mailing list