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?
---------------------------------------------------------------------
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
