Skip navigation links
MySQL 5.0 Reference Manual :: 13 SQL Statement Syntax :: 13.3 MySQL Transactional and Locking Statements
13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax »
Section Navigation      [Toggle]

13.3. MySQL Transactional and Locking Statements

13.3.1. START TRANSACTION, COMMIT, and ROLLBACK Syntax
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, and Syntax
13.3.5. LOCK TABLES and UNLOCK TABLES Syntax
13.3.6. SET TRANSACTION Syntax
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 Syntax”. Beginning with MySQL 5.0, XA transaction support is available, which enables MySQL to participate in distributed transactions as well. See Section 13.3.7, “XA Transactions”.

Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices