How to add a value to existing value using SQL query

Question

I have a table named products.

Products
    Quantity
    5

I need to update Quantity by any value; for example, adding 3 to the current value, giving output like below:

Quantity
8

How can I write an SQL query to accomplish this?

update products set quantity = quantity + 3 ? (adding a where clause) — jbl
– jbl, Commented Nov 15, 2012 at 11:00

juergen d · Accepted Answer · 2012-11-15 11:00:27Z

65

update products
set quantity = quantity + 3

answered Nov 15, 2012 at 11:00

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Manatherin · Accepted Answer · 2012-11-15 11:03:21Z

5

declare @table table(id int, quantity int)
insert into @table values(1, 5)

update @table
set quantity = quantity + 3
output inserted.quantity

Assuming that you actually wanted the value outputted. Don't forget any where clauses that may be needed

answered Nov 15, 2012 at 11:03

Manatherin

4,2075 gold badges40 silver badges52 bronze badges

Tohid Makari · Accepted Answer · 2023-01-30 10:51:22Z

0

Jus in case, for string value, it should be as follows :

update products
set quantity = concat(quantity, '3')

answered Jan 30, 2023 at 10:51

Tohid Makari

2,5645 gold badges24 silver badges42 bronze badges