在不带PHP的MYSQL上将表字段更新为其值和常量 [英] Update a Table Field to its Value Plus a Constant on MYSQL w/o PHP

问题描述

我想在MYSQL中执行一个UPDATE，其中我要获取一个字段值，添加一个常量并将新值保存在同一字段中.

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.

我们假设在名为aTable的表中有一个名为OldValue的列.

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

伪代码可能是:

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

您对我该怎么做有任何想法吗?我想使用一个查询(在某些管理面板上)而不制作php脚本. (当然，在这种情况下，答案很简单.)

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.)

推荐答案

您的代码将可用.

查看它在SQLFiddle中的作用.

我使用了您确切的查询字词，只是用一个真实值代替了"someValue".

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

这篇关于在不带PHP的MYSQL上将表字段更新为其值和常量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！