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

49 votes217 views6 answers
Mysql add column to table
SQL
0 vote147 views1 answer
Delet all record statment sql
SQL
3 votes157 views1 answer
How to add unique constraint in mysql table
SQL
2 votes153 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
2 votes123 views1 answer
Sql create database
SQL
0 vote129 views1 answer
Price-colour
SQL
0 vote248 views1 answer
How to delete duplicate rows in oracle
SQL
1 vote119 views1 answer
Use of now() in mysql
SQL
0 vote145 views1 answer
Sql describe
SQL
1 vote140 views2 answers
Foreign key set 0
SQL