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 vote159 views1 answer
Object of class mysqli_result could not be converted to string
SQL
6 votes156 views2 answers
Mysql convert timestamp to date
SQL
1 vote159 views3 answers
Reset sql primary key
SQL
0 vote153 views1 answer
Run postgresql dump to csv
SQL
1 vote164 views1 answer
Mysql average of multiple columns
SQL
7 votes123 views1 answer
Mysql load data infile csv
SQL
1 vote234 views4 answers
Alter schema sql
SQL
2 votes145 views1 answer
When matched in sql server
SQL
0 vote164 views1 answer
Sqlalchemy get schema from database
SQL
0 vote147 views1 answer
SQL column name Oracle
SQL