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 vote184 views1 answer
Deleted table in sql trigger
SQL
0 vote247 views1 answer
Error code 1241 mysql
SQL
0 vote213 views1 answer
Access refused mysql xampp server
SQL
0 vote217 views1 answer
Multiple left join mysql
SQL
24 votes228 views6 answers
Replace mysql
SQL
4 votes226 views2 answers
Error loading MySQLdb module.
SQL
0 vote231 views1 answer
Sql_inner_join
SQL
1 vote231 views1 answer
Md5 encryption for existing records
SQL
0 vote175 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote350 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL