13.4.3. Statements That Cause an Implicit Commit
Each of the following statements (and any synonyms for them)
implicitly end a transaction, as if you had done a
COMMIT before executing the statement:
LOAD MASTER DATA,
UNLOCK TABLES commits a transaction only
if any tables currently are locked.
CREATE TABLE statement in
InnoDB is processed as a single
transaction. This means that a
from the user does not undo
statements the user made during that transaction.
Transactions cannot be nested. This is a consequence of the
COMMIT performed for any current
transaction when you issue a
TRANSACTION statement or one of its synonyms.