>Win32 MySQL Version 3.21.29a-gamma-debug
>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
Paul DuBois, paul@stripped