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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Saturday, January 06, 2007 4:10 AM
Subject: On Duplicate Key Update question
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 a query like this but instead of replacing
the value of the previous Qty I'd like it to take the old Qty and the
new Qty and store the sum of the two values in the Qty field.
Is this possible and can anyone tell me how?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
