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

9 votes202 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote208 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote216 views1 answer
Guid string to binary better
SQL
8 votes234 views3 answers
Connect python to mysql
SQL
0 vote229 views2 answers
Raise notice in postgresql function
SQL
0 vote235 views1 answer
Psotgres multiple values
SQL
5 votes229 views2 answers
Sql number columns
SQL
1 vote215 views1 answer
Select if then postgresql
SQL
2 votes220 views1 answer
Sql as
SQL
0 vote214 views1 answer
Mysql add comment to column
SQL