SyntaxFix

[postgresql] Increment a value in Postgres 

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;

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?