Update Statement
| From: | Ng Hwee Hwee | Date: | Wed, 18 Feb 2004 02:14:37 +0000 |
| Subject: | Update Statement | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32990@lists.php.net to get a copy of this message | ||
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