BEGIN and COMMIT

Open and close a transaction.

BEGIN starts the transaction, COMMIT makes changes permanent.

BEGIN;
INSERT INTO orders (id, amount) VALUES (1, 50);
COMMIT;

The order is permanently added.

BEGIN and COMMIT — details

Until COMMIT, changes are temporary. After COMMIT, other sessions can see them.

For example, the two updates between BEGIN; UPDATE …; UPDATE …; COMMIT; become visible to other users at the same moment.

Write an INSERT transaction: BEGIN, INSERT, COMMIT.

Show example solution

BEGIN;
INSERT INTO orders (id, amount) VALUES (1, 50);
COMMIT;

Add COMMIT

BEGIN;
INSERT INTO orders (id, amount) VALUES (1, 50);
____;

Show answer

BEGIN;
INSERT INTO orders (id, amount) VALUES (1, 50);
COMMIT;

Next lesson: ROLLBACK