[+/-]
START TRANSACTION
,
COMMIT
, and
ROLLBACK
SyntaxSAVEPOINT
and
ROLLBACK TO
SAVEPOINT
SyntaxLOCK TABLES
and
UNLOCK
TABLES
SyntaxSET TRANSACTION
Syntax
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.