How to decrease the value in the database?

W

WeBBeW2018-02-11 20:41:20

MySQL

WeBBeW, 2018-02-11 20:41:20

For example, a column with the name - nubmer the value of the nubmer column is 1000.
How can I subtract 10 from 1000 with mysql_query, for example?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Sergey Gornostaev, 2018-02-11
@WeBBeW

mysql_query('update some_table set nubmer = nubmer - 10 where nubmer = 1000')

Similar questions

A

Alexander Shestakov2020-04-28 13:04:10

T

touchilka2020-04-28 13:09:05

A

B

Boris2018-02-27 01:58:41

V

Vyacheslav Mulyukin2015-10-23 23:07:09

Didn't find what you were looking for?