mysql v4.x
Posted: Wed Sep 03, 2003 3:36 pm
does it support JOINS in UPDATE statements? if not, will verstion 5? anyone have any ideas?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
The Manual wrote:Starting with MySQL Version 4.0.4, you can also perform UPDATE operations that cover multiple tables:
Code: Select all
UPDATE items,month SET items.price=month.price WHERE items.id=month.id;