Way to increment / decrement field value with MySQL / PHP?

Question

I want to increment or decrement the value of a field in a mysql table and i was wondering if there is an easier way than what i thought of...
1. Get value, 2. value++, 3. Update value on Mysql.
That seems really inefficient to me (2 query calls just to push a number up by one), so i thought maybe mysql has a function to do this automatically. Thanks for the help.

Answer 1

You can do it with a single UPDATE query:

UPDATE the_table SET the_field = the_field + 1
WHERE [your WHERE clause]

Answer 2

you can use a query to increment or decrement a field in just one query:

"update table set field = field+1 where ..."

Answer 3

The good judgment seems real. yet i think of you go with expenses around the replace assertion, by way of fact it relatively is a string. attempt doing it in smaller steps, and print out the sq. replace statements by way of fact this technique runs, this way it's going to be much less complicated to debug: for($i=0; $i