Hello all,
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?