MySQL 5.5 Reference Manual :: 12 SQL Statement Syntax :: 12.3 MySQL Transactional and Locking Statements
Section Navigation [Toggle]
- 12 SQL Statement Syntax
- 12.1 Data Definition Statements
- 12.2 Data Manipulation Statements
- 12.3 MySQL Transactional and Locking Statements
- 12.4 Database Administration Statements
- 12.5 Replication Statements
- 12.6 SQL Syntax for Prepared Statements
- 12.7 MySQL Compound-Statement Syntax
- 12.8 MySQL Utility Statements
[+/-]
- 12.3.1.
START TRANSACTION,COMMIT, andROLLBACKSyntax - 12.3.2. Statements That Cannot Be Rolled Back
- 12.3.3. Statements That Cause an Implicit Commit
- 12.3.4.
SAVEPOINTandROLLBACK TO SAVEPOINTSyntax - 12.3.5.
LOCK TABLESandUNLOCK TABLESSyntax - 12.3.6.
SET TRANSACTIONSyntax - 12.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 12.3.1, “START TRANSACTION,
COMMIT, and
ROLLBACK Syntax”. XA transaction support enables MySQL to
participate in distributed transactions as well. See
Section 12.3.7, “XA Transactions”.
User Comments
Add your own comment.