I have a table with few columns, one of these columns called _bandwidth and the value inside it is decimal.
So i wanna type a sql query that adds values to existing value.
Say the value of _bandwidth of user id 1 is 150.000 and i wanna add 200 to this value so sum would be 350.000
This is the query i typed but it didin't work.
update users set _bandwidth = (select _bandiwdth from users where _ID = 1) + 150 where _ID = 1
update users set _bandwidth += 200 where _ID = 1
update users set _bandwidth = _bandwidth + 200 where _ID = 1