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

21 votes178 views4 answers
Oracle add column
SQL
12 votes167 views2 answers
Insert multiple rows from another table sql
SQL
0 vote237 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote166 views1 answer
Show the colums of table sql
SQL
0 vote172 views1 answer
How to add timestamp column in mysql
SQL
2 votes179 views1 answer
Grant revoke privileges to mysql username
SQL
1 vote162 views1 answer
Group_concat order by
SQL
1 vote172 views2 answers
Snowflake alter column data type
SQL
-1 vote157 views1 answer
How to use update trigger in sql
SQL
1 vote180 views1 answer
Full sql mode
SQL