Start a transaction

sql

START TRANSACTION;

Explanation

Explicit transactions let you group related writes into a single atomic unit.

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

Persist all changes made in the current transaction.

Open In sheetsqlsame section

Undo all uncommitted changes.

Open In sheetsqlsame section

Undo only part of a transaction.

Open In sheetsqlsame section

Keep statements in a transaction until you commit or rollback.

Open In sheetsqlsame section

Control read consistency and concurrency behavior.

Open In sheetsql1 tag match

Prevent concurrent modifications to matched rows inside a transaction.