13.3 Transactional and Locking Statements
- 13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements
- 13.3.2 Statements That Cannot Be Rolled Back
- 13.3.3 Statements That Cause an Implicit Commit
- 13.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
- 13.3.5 LOCK TABLES and UNLOCK TABLES Statements
- 13.3.6 SET TRANSACTION Statement
- 13.3.7 XA Transactions
MySQL supports local transactions (within a given client session) through statements such as SET autocommit
, START TRANSACTION
, COMMIT
, and ROLLBACK
. See Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”. XA transaction support enables MySQL to participate in distributed transactions as well. See Section 13.3.7, “XA Transactions”.