| 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
which ver of mysql are you using? multiple table update is possible only
with ver starting from 4.0.4.
HTH..
Nitin
- Original Message -
From: "Laercio Xisto Braga Cavalcanti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Fri
'm using Multiple-table Update with the above sintax:
mysql> desc italica;
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---+
| ita_empresa | decimal(10,0)
update gci_copy,dis set
gci_copy.products_description=concat_ws('',gci_copy.products_description,dis.products_model,dis.products_description)
where gci_copy.products_image=dis.products_image
only able to caoncat one match
possiable work arounds.
__
