Summary - Transaction

Write a money transfer with BEGIN, COMMIT and ROLLBACK.

A transaction starts with BEGIN, commits with COMMIT or rolls back with ROLLBACK. It provides ACID properties.

BEGIN;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;

Summary transfer.

Exercise Summary - Transaction

Summary: write a money transfer transaction (BEGIN, two UPDATEs, COMMIT).

Show example solution

BEGIN;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;

Next lesson: ALTER TABLE