Cheat Sheet logoCheat Sheet Today
MySQL Transactions and Locking Cheatsheet/Disable autocommit for the session

Keep statements in a transaction until you commit or rollback.

Back to sheetBrowse commands
Sign in to save
Section: transactions

Disable autocommit for the session

sql
sql
SET autocommit = 0;
Explanation

Use carefully; long-lived transactions can hold locks and increase contention.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing transactions
Start a transaction
Begin a transaction explicitly.
OpenIn sheetsqlsame section
Commit a transaction
Persist all changes made in the current transaction.
OpenIn sheetsqlsame section
Rollback a transaction
Undo all uncommitted changes.
OpenIn sheetsqlsame section
Set and rollback to a savepoint
Undo only part of a transaction.
OpenIn sheetsqlsame section
Lock selected rows for update
Prevent concurrent modifications to matched rows inside a transaction.
OpenIn sheetsql
Lock rows for shared reads
Read rows while protecting against conflicting writes.
OpenIn sheetsql