Postgresql transaction

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 vote182 views1 answer
Except in sql alchemy
SQL
0 vote177 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote178 views1 answer
Casterar postgres
SQL
3 votes165 views1 answer
Mysql UPDate with enner join
SQL
2 votes186 views3 answers
Current month mysql query
SQL
0 vote154 views1 answer
Month mysql
SQL
2 votes190 views2 answers
Mysql write into table
SQL
2 votes178 views1 answer
Mysql sysdate
SQL
0 vote186 views1 answer
Import sql in postgresql
SQL
0 vote193 views1 answer
Oracle query to find schema you are working on
SQL