It seems this issue will be fixed in 4.0.13, I filed a bug and it was
closed with this report:
Sinisa Milivojevic:
Yes, this is a known problem.
It is already fixed in 4.0.13, which will come out this month.
This is a patch:
= sql/sql_update.cc 1.79 vs 1.80 =
*** /tmp/sql_update.cc-1.79
I've seen this on the mailing lists just a day ago ('*have a problem'*),
and wow! I have a similar problem.
None of the suggestions in the online documentation helped. I tried both
MyISAM and InnoDB table formats. This obviously only works on MySQL
>=4.0 (I'm running the 4.0.12 RPM on Linux).
U
When will MySql support the UPDATE statement with more then one table.
E.g. UPDATE table1, table2 SET table1.col1=table2.col1 WHERE ...
Or ist there a work around?
Many regards,
Michael
-
Before posting, please check:
http
