mysql v4.x
Moderator: General Moderators
mysql v4.x
does it support JOINS in UPDATE statements? if not, will verstion 5? anyone have any ideas?
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;