mysql 更新数字 常量,在不带PHP的MYSQL上将表字段更新为其值和常量

I would like to perform an UPDATE in MYSQL in which I take a field value, add a constant and save the new value in the same field.

Let's assume that we have a column called OldValue in a table called aTable.

Pseudocode could be:

UPDATE aTable SET OldValue = OldValue + 220 WHERE someField = someValue

Do you have any idea on how I could do that? I would like to use a single query (on some administration panel) without making a php script. (Of course, in that case the answer is quite simple.)

解决方案

Your code will work.

I used your exact query verbatim, except for substituting a real value for "someValue".