List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 5 2002 4:31pm
Subject:Re: Escaped by 2 things?
View as plain text  
At 21:45 -0800 4/4/02, Cliff wrote:
>Short and simple, is it possible to escape by two different parameters? This
>used to work:

I think you are mistaken.  I just checked the grammar files for 90
versions of MySQL, and that syntax isn't legal in any of them.

I don't see how it could be legal, either.  Should MySQL have to escape
a character, which escape character would it use?

>SELECT * from allusa WHERE (updated_by='I' or updated_by='A' or
>updated_by='L') AND (id<90000) AND last_updated > '20020201000000' ORDER BY
>last_updated INTO OUTFILE
>'/home/www/site/admin/admin/dbdump/bb2002020107000000.txt' FIELDS TERMINATED
>BY ' ' ENCLOSED BY '"' ESCAPED BY ('\\\\' && '\n');
>but now it gives the error:
>ERROR 1064: You have an error in your SQL syntax near '&& ' '' at line 1
>anyone know if this is possible?

Escaped by 2 things?Cliff5 Apr
  • Re: Escaped by 2 things?Paul DuBois5 Apr
RE: Escaped by 2 things?Rick Emery5 Apr