"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.
| 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. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/transactions/