12.3. MySQL Transactional and Locking Statements
Prev Chapter 12. SQL Statement Syntax Next

12.3. MySQL Transactional and Locking Statements

12.3.1. START TRANSACTION, COMMIT, and ROLLBACK Syntax
12.3.2. Statements That Cannot Be Rolled Back
12.3.3. Statements That Cause an Implicit Commit
12.3.4. SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax
12.3.5. LOCK TABLES and UNLOCK TABLES Syntax
12.3.6. SET TRANSACTION Syntax
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”.

Copyright © 1997, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices
Prev Up Next
12.2.11. UPDATE Syntax Home 12.3.1. START TRANSACTION, COMMIT, and ROLLBACK Syntax
Copyright © 2010-2024 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout