I’m a tad worried that this is a simple SQL question, and not a MySQL performance question, so if thats the case, my apologies.
I’m looking to increase (or decrease) the value of an int field by a set amount (usually 1), without calling a SELECT statement first.
Right now, i am doing a SELECT to find the value, then doing an UPDATE with the new value.
I hope there is a way of just doing an UPDATE with a function, but i have yet to find it (and my bad english is slowing the search).
Thanks
Kev
P.S. While not a performace quesstion iteself, it would save me 1 DB call everytime i want to do this, which happens alot on my system.