Transaction scenario

Write a safe transfer with a transaction.

In this challenge you will write a money transfer transaction: BEGIN, two UPDATEs, COMMIT.

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

A safe money transfer.

Exercise Transaction scenario

Write a 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;

Add COMMIT

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

Show answer

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