is it possible to update fields of a table with values taken
from another
table? Like this (illegal) command would do:
UPDATE b SET b.v = a.v WHERE b.id = a.id;
Not yet.
Multi-table deletes/updates are planned for MySQL 4.0, AFAIK.
Then I have to stick to the method I am currently
Hi,
is it possible to update fields of a table with values taken from another
table? Like this (illegal) command would do:
UPDATE b SET b.v = a.v WHERE b.id = a.id;
Jens
-
Before posting, please check:
Hello.
On Wed, Jun 20, 2001 at 08:27:19PM +0200, [EMAIL PROTECTED] wrote:
is it possible to update fields of a table with values taken from another
table? Like this (illegal) command would do:
UPDATE b SET b.v = a.v WHERE b.id = a.id;
Not yet.
Multi-table deletes/updates are planned for