| 10 |
+--+--+
4 rows in set (0.00 sec)
Thanks
ViSolve DB Team.
- Original Message -
From: "Thomas Spahni" <[EMAIL PROTECTED]>
To:
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2007 3:57 PM
Subject: Multiple-table UPDATE unexpected result
Dear listmember
Dear listmembers
On mysql version 4.1.13 I execute a query of this type:
UPDATE a
LEFT JOIN b ON a.col = b.col
SET a.x = a.x + b.y
WHERE b.col IS NOT NULL;
I expect that column a.x is updated for every match in the join but this
is not the case. Table a is updated for the first match only as
