[postgresql] Increment a value in Postgres

I'm a little new to postgres. I want to take a value (which is an integer) in a field in a postgres table and increment it by one. For example if the table 'totals' had 2 columns, 'name' and 'total', and Bill had a total of 203, what would be the SQL statement I'd use in order to move Bill's total to 204?

This question is related to postgresql increment

The answer is

UPDATE totals 
   SET total = total + 1
WHERE name = 'bill';

If you want to make sure the current value is indeed 203 (and not accidently increase it again) you can also add another condition:

UPDATE totals 
   SET total = total + 1
WHERE name = 'bill'
  AND total = 203;

Source: Stackoverflow.com

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to increment

• How to increment a letter N times per iteration and store in an array? • How to increment a number by 2 in a PHP For Loop • Can a for loop increment/decrement by more than one? • Increment a value in Postgres • R: += (plus equals) and ++ (plus plus) equivalent from c++/c#/java, etc.? • Ruby: How to iterate over a range, but in set increments? • Increment a database field by 1 • Python integer incrementing with ++ • What is the difference between i++ & ++i in a for loop? • How can I increment a char?

[postgresql] Increment a value in Postgres

The answer is

Examples related to postgresql

Examples related to increment

Tags