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

16 votes113 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote111 views1 answer
How to find columns with null values in sql
SQL
0 vote106 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote117 views1 answer
Show all mongodb
SQL
0 vote129 views1 answer
Show all sequences postgres
SQL
1 vote134 views1 answer
Oracle grant select on schema
SQL
0 vote102 views1 answer
Psql list rules
SQL
0 vote102 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
22 votes133 views1 answer
Mysql workbench
SQL
0 vote116 views1 answer
Mysql average from two table
SQL