SQL · Transactions and integrity

transaction

Groups statements so they succeed or fail together. A rollback undoes the whole group.

sqlRunnable example sql course

Syntax

begin; … commit;

Example

Open in the lab

BEGIN;
CREATE TEMP TABLE notes (body TEXT);
INSERT INTO notes VALUES ('inside');
COMMIT;
SELECT * FROM notes;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.