Transactions

"An SQL-transaction (transaction) is a sequence of executions of SQL-statements that is atomic with respect to recovery. That is to say: either the execution result is completely successful, or it has no effect on any SQL-schemas or SQL-data."

— The SQL Standard

The InnoDB storage engine supports ACID-compliant transactions.

Transaction Articles

Title Description
START TRANSACTION Basic transaction control statements.
COMMIT Ends a transaction, making changes visible to subsequent transactions
ROLLBACK Cancel current transaction and the changes to data
SET TRANSACTION Sets the transaction isolation level.
LOCK TABLES Explicitly lock tables.
SAVEPOINT SAVEPOINT for a ROLLBACK.
Metadata Locking A lock which protects each transaction from external DDL statements.
SQL statements That Cause an Implicit Commit List of statements which implicitly commit the current transaction
Transaction Timeouts Timing out idle transactions
UNLOCK TABLES Explicitly releases any table locks held by the current session.
WAIT and NOWAIT Extended syntax so that it is possible to set lock wait timeout for certain statements.
XA Transactions Transactions designed to allow distributed transactions.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/transactions/