Re: Update Statement
| From: | pete M | Date: | Wed, 18 Feb 2004 12:52:30 +0000 |
| Subject: | Re: Update Statement | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32998@lists.php.net to get a copy of this message | ||
This one cooked me 2 when I realised my online by was 3x and local was 4x
only 4+ supports a join on an update statement
from the manual
Starting with MySQL Version 4.0.4, you can also perform UPDATE operations that cover multiple tables:
UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;
pete
Ng Hwee Hwee wrote:
hi all, I would like to do the following: update Table1, Table2 set Table1.field1 = Table2.field2 where Table1.no = Table2.no however, i found that multiple updates can only work for MySQL version 4.0.4 but mine is 3.23.54... can anyone enlighten me on how I can achieve the same results with this older MySQL version? or can PHP 4.2.2 help me in any way? Thank you so much! Hwee