Originally Posted by sanomani
Additionally, can you tell which query should run faster?
"update `table` set `point` = '100'"
"update `table` set `point` = `point` + '1'"
Once again, I have to ask: Why didn't you simply TRY IT???
I would expect them to both run at nearly identical speed.
You are changing the value of the field point
in EACH AND EVERY RECORD of the table
. So MySQL has no choice but to simply scan the entire table and change every record. I doubt seriously that the slight extra overhead of fetching the field value before changing it will ever be noticeable.