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?

Accepted Answer

```
update products
set quantity = quantity + 3
```

How to add a value to existing value using SQL query

Solution

Problem