Did you upgrade to 4.0.17 or 4.1.7? In 4.1, you have to use the alias
between FROM and USING:
DELETE FROM rls USING rsrc_linx_specialty rls,...
This is documented at the bottom of the manual page you referenced.
Michael
[EMAIL PROTECTED] wrote:
I had a working query that suddenly doesn't work anymore.
It follows the syntax found in the documentation at
http://dev.mysql.com/doc/mysql/en/DELETE.html
specifically,
DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id;
my query is:
DELETE FROM rsrc_linx_specialty USING rsrc_linx_specialty rls, rsrc_linx
rl, rsrc_linx_type rlt WHERE rls.specialtyID = '$specialtyIDd' AND
rls.sectorID = '$sectorIDd' AND rls.linxID = rl.linxID AND rl.linxID =
rlt.linxID AND rlt.typeID = '2';
I'd been using this query successfully for a while.
Then we upgraded to 4.0.17 and now it doesn't work neither from a PHP
page, nor a terminal session.
I get an error found to start at the word 'USING'.
I've checked/optimized the table. I've searched on the web for faqs and
everything, but haven't found any pertinent information. So if it isn't a
corrupt table, I'm wondering if the "USING" parameter happened to be
deprecated, or something..
Any suggestions would be appreciated 'cause right now I'm stumped.
Cameron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
