[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