List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 22 1999 5:46pm
Subject:Re: DATA INFILE QUESTION
View as plain text  
>Win32 MySQL Version 3.21.29a-gamma-debug
>
>Hi
>
>In the manual it says ...
>
>Duplicated ENCLOSED BY chars are removed from strings that start with
>ENCLOSED BY. For example: With ENCLOSED BY '"':
>
>"The ""BIG"" boss"  -> The "BIG" boss
>The "BIG" boss      -> The "BIG" boss
>
>which is exactly what I want to do, but when I try I get an error as follows
>... :
>
>mysql> load data infile 'address_72299.txt' into table employee ENCLOSED BY
>'"';
>
>ERROR 1064: parse error near 'ENCLOSED BY '"'' at line 1
>
>Any ideas ??

This is telling you that the word ENCLOSED was not expected at that point
in the statement.  And that's correct, because you're missing something.
You need FIELDS in front of ENCLOSED BY.  Check the manual for the full
syntax.

-- 
Paul DuBois, paul@stripped
Thread
DATA INFILE QUESTIONDarren L Sweeney22 Jul
  • Re: DATA INFILE QUESTIONPaul DuBois22 Jul
RE: DATA INFILE QUESTIONDarren L Sweeney22 Jul