Written by me@grafxflow
08 Nov, 2012
1
28,902
If you have a numerical value in a MySQL database table, that you want to UPDATE by adding a value to it, or subtracting a value from it. This can be done with a single MySQL query.
So for an example, I have a database with a product which has a quantity of 10 in stock, somebody has just bought 5 so I need to subtract that value from the database quantity.
UPDATE products_table SET quantity = quantity - 5 WHERE product_id = 21
Later in the shop admin you receive new stock and so need to UPDATE the product quantity by adding 5 new items to its current quantity of 5.
UPDATE products_table SET quantity = quantity + 5 WHERE product_id = 21
01 Aug, 2015
28 Nov, 2012
I am a Full-stack Developer who also started delving into the world of UX/UI Design a few years back. I blog and tweet to hopefully share a little bit of knowledge that can help others around the web. Thanks for stopping by!
Follow11 Jul, 2023
21 Jun, 2023
25 Nov, 2022
20 Sep, 2022
Views: 162,260
Views: 38,652
Views: 34,326
Views: 31,726
1 Response
java tutorial
15 Aug 2013