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

6 votes226 views5 answers
Get current date sql
SQL
0 vote229 views1 answer
Set open file limit mac catalina mysql
SQL
2 votes242 views1 answer
Column names in oracle sql
SQL
0 vote234 views2 answers
Mysql to python pandas
SQL
22 votes264 views3 answers
How to join three tables in sql using joins
SQL
0 vote236 views3 answers
Sql all columns
SQL
1 vote234 views1 answer
Oracle list data files
SQL
0 vote235 views1 answer
Plsql check for string in numeric
SQL
0 vote256 views1 answer
Mysql insert into select transaction c#
SQL
0 vote243 views1 answer
Get all employee of salary if more than in sql
SQL