Turns out to be 4.1.7
This suggestion fixed my query, thanks.
I'd tried that approach yesterday, but it was on an older
version of MySQL (on our non-production server; I wasn't paying attention
to the versions of MySQL betw. our test and production servers) - so my
previous attempts with this syn
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
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_
