MySQL 5.0 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”. Beginning with MySQL 5.0, XA transaction
support is available, which enables MySQL to participate in
distributed transactions as well. See Section 12.3.7, “XA Transactions”.
User Comments
Add your own comment.