Skip navigation links

Additional languages
MySQL 5.0 Reference Manual :: 12 SQL Statement Syntax :: 12.4 MySQL Transactional and Locking Statements
12.4.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax »
Section Navigation      [Toggle]

12.4. MySQL Transactional and Locking Statements

[+/-]

12.4.1. START TRANSACTION, COMMIT, and ROLLBACK Syntax
12.4.2. Statements That Cannot Be Rolled Back
12.4.3. Statements That Cause an Implicit Commit
12.4.4. SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax
12.4.5. LOCK TABLES and UNLOCK TABLES Syntax
12.4.6. SET TRANSACTION Syntax
12.4.7. XA Transactions

MySQL supports local transactions (within a given client connection) through statements such as SET AUTOCOMMIT, START TRANSACTION, COMMIT, and ROLLBACK. See Section 12.4.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”. Beginning with MySQL 5.0, XA transaction support is available, which enables MySQL to participate in distributed transactions as well. See Section 12.4.7, “XA Transactions”.