> >>>>>>I didn't see any difference between using optionally or not. Any
> solutions to make the two that fails work? (see test case below) Using
> 3.23.41.
>
> That's a problem with your input data. You can't have the character that
> you're using to surround the fields within the field, unless you escape
> it.
> If you can re-export the data, use a surrounding character that's not in
> the dataset to enclose your fields, or make sure that every instance of
> the surrounding character (and the escape char) are escaped by some other
> character (ie ESCAPED BY '\')
>
> Chris
>
database,sql,query,table
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
