Dbms transaction (psql)

BEGIN;
UPDATE accounts SET balance = balance - 100.00
    WHERE name = 'Alice';
SAVEPOINT my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Bob';
-- oops ... forget that and use Wally's account
ROLLBACK TO my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Wally';
COMMIT;

Source: postgresql.org

Similar codes

24 votes250 views2 answers
Alter table delete column
SQL
61 votes407 views6 answers
Mysql add column
SQL
8 votes248 views1 answer
Insert a select statement into a table
SQL
0 vote234 views1 answer
Parsing float to int in mysql
SQL
0 vote263 views1 answer
Mysql join only one column
SQL
3 votes250 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote260 views1 answer
Mysql url data type
SQL
0 vote253 views1 answer
Sql get guid
SQL
0 vote278 views1 answer
Mysql add to number
SQL
4 votes241 views2 answers
Tables in sql
SQL