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 vote171 views1 answer
Openquery insert into linked server
SQL
0 vote165 views1 answer
Find largest table in mysql database
SQL
1 vote152 views1 answer
Mysql select utc time in eastern time
SQL
0 vote181 views1 answer
Start stop mysql linux
SQL
8 votes195 views2 answers
Replace string value in sql
SQL
0 vote169 views2 answers
How to save result of sqlite query in a table
SQL
0 vote167 views1 answer
Sql count total by foreign key
SQL
7 votes170 views1 answer
Minecraft forge server host
SQL
0 vote168 views1 answer
SQL Server Altering Column to be Unique
SQL
6 votes152 views1 answer
Phpmyadmin reset root password
SQL