Hi,
From your query, understood that you want to retain old qty and new qty;
result in another field.
Try with,
INSERT INTO TABLE1 (id,newqty) values (6,300) ON DUPLICATE KEY UPDATE
totqty=oldqty+newqty, oldqty=newqty;
Thanks,
ViSolve DB Team
- Original Message -
From: "Ed Reed"
Ed Reed wrote:
I use On Duplicate Key Update a lot and I usually use it like this,
Insert Into tablename (myID, Qty)
Values (1034,15),
(6,13),
(5001,1),
(145,20) On Duplicate Key Update Qty=Values(Qty);
This works very well but now I'd like to do something a little
different. I'd like to have
Sorry for the premature question. I think I figured it out.
On Duplicate Key Update Qty=Qty+Values(Qty);
I haven't tested it yet but it makes sense that it'll work.
>>> "Ed Reed" <[EMAIL PROTECTED]> 1/5/07 2:40 PM >>>
I use On Duplicate Key Update a lot and I usually use it like this,
Inser
