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

4 votes180 views3 answers
Mysql modify foreign key
SQL
0 vote171 views1 answer
Create new schema mysql
SQL
0 vote171 views5 answers
Linq cheat sheet
SQL
6 votes186 views2 answers
Clear a table in mysql
SQL
2 votes173 views2 answers
Install sqlalchemy
SQL
0 vote186 views1 answer
Char vs varchar2 in sql
SQL
0 vote187 views1 answer
Like date sql server not working
SQL
5 votes173 views2 answers
Ranking functions in sql
SQL
0 vote185 views1 answer
Faire une recherche par liste de mot clé sql
SQL
10 votes190 views2 answers
SQL rounding numbers
SQL