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

0 vote180 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
1 vote144 views3 answers
Sql union
SQL
0 vote96 views1 answer
Calculate discount from original price sql
SQL
2 votes142 views3 answers
Current month mysql query
SQL
1 vote151 views1 answer
Sql row having max
SQL
3 votes134 views2 answers
Oracle apex charging debug
SQL
0 vote139 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote175 views1 answer
Get first monday of month sql
SQL
1 vote141 views1 answer
Oracle get current schema
SQL
0 vote140 views1 answer
Count columns psql(PostreSQL)
SQL