Results 1 to 2 of 2
May 4, 2012, 23:35 #1
- Join Date
- Apr 2011
- Mexico city, Mexico
- 1 Post(s)
- 0 Thread(s)
Can I add the values of a current column to an int
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?Do you get bothered because I do the same thing every day?
Do you question why I do it?
Then find something that you actually like doing!!!
Stop thinking on what I do.