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?