Page 1 of 1

mysql v4.x

Posted: Wed Sep 03, 2003 3:36 pm
by liljester
does it support JOINS in UPDATE statements? if not, will verstion 5? anyone have any ideas?

Posted: Wed Sep 03, 2003 8:44 pm
by JAM
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;