SQLite - increase value by a certain number
Solution 1:
Example 1 (for all rows):
UPDATE product SET price = price + 50
Example 2 (for a specific row):
UPDATE product SET price = price + 50 WHERE id = 1
Example 3 (for specific rows):
UPDATE product SET price = price + 50 WHERE id IN [1, 2, 3]
Example 4 (generic):
UPDATE {table} SET {column} = {column} + {value} WHERE {condition}
Where:
-
{table}- table name -
{column}- column name -
{value}- a number by which column's value should be increased or decreased -
{condition}- some condition if any