I have 2 columns, total and last_value
can I do something like
UPDATE values SET total= total+3 WHERE id = 1
from the above query the total is the current total, can I do that in one query or first I have to get the current value in a query and then make a second one to update the value?
I guess I was doing something wrong because that exact same query now works.
This topic is now archived. It is frozen and cannot be changed in any way.