Start a transaction

sql

BEGIN;
INSERT INTO audit_log(action) VALUES ('start');
UPDATE counters SET value = value + 1 WHERE key = 'jobs';
COMMIT;

Explanation

Wrapping related writes in one transaction improves consistency and often performance.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Transactions and savepoints

Reserve the write lock up front.

Open In sheetsqlsame section

Undo uncommitted changes.

Open In sheetsqlsame section

Create a nested rollback point within a transaction.

Open In sheetsqlsame section

Switch the database to write-ahead logging mode.

Open In sheetsql1 tag match

Wait briefly when the database is locked.

Open In sheetsql1 tag match

Merge WAL contents back into the main database file.

Open In sheetsql1 tag match