定义或修改数据库对象的数据定义语言（DDL）语句。 ALTER EVENT, ALTER FUNCTION, ALTER PROCEDURE, ALTER SERVER, ALTER TABLE, ALTER TABLESPACE, ALTER VIEW, CREATE DATABASE, CREATE EVENT, CREATE FUNCTION, CREATE INDEX, CREATE PROCEDURE, CREATE ROLE, CREATE SERVER, CREATE SPATIAL REFERENCE SYSTEM, CREATE TABLE, CREATE TABLESPACE, CREATE TRIGGER, CREATE VIEW, DROP DATABASE, DROP EVENT, DROP FUNCTION, DROP INDEX, DROP PROCEDURE, DROP ROLE, DROP SERVER, DROP SPATIAL REFERENCE SYSTEM, DROP TABLE, DROP TABLESPACE, DROP TRIGGER, DROP VIEW, INSTALL PLUGIN, RENAME TABLE, TRUNCATE TABLE, UNINSTALL PLUGIN.Data definition language (DDL) statements that define or modify database objects. ALTER EVENT, ALTER FUNCTION, ALTER PROCEDURE, ALTER SERVER, ALTER TABLE, ALTER TABLESPACE, ALTER VIEW, CREATE DATABASE, CREATE EVENT, CREATE FUNCTION, CREATE INDEX, CREATE PROCEDURE, CREATE ROLE, CREATE SERVER, CREATE SPATIAL REFERENCE SYSTEM, CREATE TABLE, CREATE TABLESPACE, CREATE TRIGGER, CREATE VIEW, DROP DATABASE, DROP EVENT, DROP FUNCTION, DROP INDEX, DROP PROCEDURE, DROP ROLE, DROP SERVER, DROP SPATIAL REFERENCE SYSTEM, DROP TABLE, DROP TABLESPACE, DROP TRIGGER, DROP VIEW, INSTALL PLUGIN, RENAME TABLE, TRUNCATE TABLE, UNINSTALL PLUGIN.

CREATE TABLE 和 DROP TABLE 语句如果使用 TEMPORARY。（这不适用于临时表上的其他操作，如ALTER TABLE 和 CREATE INDEX，这些操作确实会导致提交。）然而，虽然不发生隐式提交，但该语句也无法回滚，这意味着使用此类语句会导致事务原子性被违反。例如，如果你使用 CREATE TEMPORARY TABLE回滚该事务，该表依然存在。CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. (This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE INDEX, which do cause a commit.) However, although no implicit commit occurs, neither can the statement be rolled back, which means that the use of such statements causes transactional atomicity to be violated. For example, if you use CREATE TEMPORARY TABLE and then roll back the transaction, the table remains in existence.

CREATE TABLE 语句 InnoDB 作为单一事务处理。这意味着 ROLLBACK 不会撤销 CREATE TABLE 语句。The CREATE TABLE statement in InnoDB is processed as a single transaction. This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction.

CREATE TABLE ... SELECT在创建非临时表时，SELECT 会在执行该语句前后引发隐式提交。（对于 CREATE TEMPORARY TABLE ... SELECT。）CREATE TABLE ... SELECT causes an implicit commit before and after the statement is executed when you are creating nontemporary tables. (No commit occurs for CREATE TEMPORARY TABLE ... SELECT.)

隐式使用或修改 mysql 数据库。ALTER USER CREATE USER，DROP USER GRANT， RENAME USER， REVOKE， SET PASSWORD.Statements that implicitly use or modify tables in the mysql database. ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD.

事务控制和锁定语句。BEGIN， LOCK TABLES， SET autocommit = 1（如果值还不是 1），START TRANSACTION， UNLOCK TABLES.Transaction-control and locking statements. BEGIN, LOCK TABLES, SET autocommit = 1 (if the value is not already 1), START TRANSACTION, UNLOCK TABLES.

UNLOCK TABLES仅在当前表已被锁定时才提交事务LOCK TABLES以获取非事务性表锁。对于UNLOCK TABLES以下情况不会发生提交FLUSH TABLES WITH READ LOCK因为后面的语句没有获取表级锁。UNLOCK TABLES commits a transaction only if any tables currently have been locked with LOCK TABLES to acquire nontransactional table locks. A commit does not occur for UNLOCK TABLES following FLUSH TABLES WITH READ LOCK because the latter statement does not acquire table-level locks.

事务不能嵌套。这是因为当你对任何当前事务执行隐式提交时，START TRANSACTION 语句或其同义Transactions cannot be nested. This is a consequence of the implicit commit performed for any current transaction when you issue a START TRANSACTION statement or one of its synonyms.

导致隐式提交的语句在事务处于 ACTIVE。Statements that cause an implicit commit cannot be used in an XA transaction while the transaction is in an ACTIVE state.

BEGIN 语句不同于 BEGIN 关键字的使用，后者以 BEGIN ... END复合语句。后者不会导致隐式提交。参见 第 15.6.1 节，“BEGIN ...结束复合语句”。The BEGIN statement differs from the use of the BEGIN keyword that starts a BEGIN ... END compound statement. The latter does not cause an implicit commit. See Section 15.6.1, “BEGIN ... END Compound Statement”.

数据加载语句。LOAD DATA.LOAD DATA仅对使用 NDB 存储引擎。Data loading statements. LOAD DATA. LOAD DATA causes an implicit commit only for tables using the NDB storage engine.

管理语句。ANALYZE TABLE”， CACHE INDEX CHECK TABLEFLUSH， LOAD INDEX INTO CACHE， OPTIMIZE TABLE，REPAIR TABLE， RESET （但不RESET PERSIST）。Administrative statements. ANALYZE TABLE, CACHE INDEX, CHECK TABLE, FLUSH, LOAD INDEX INTO CACHE, OPTIMIZE TABLE, REPAIR TABLE, RESET (but not RESET PERSIST).

Replication 控制语句。START REPLICA， STOP REPLICA， RESET REPLICA， CHANGE REPLICATION SOURCE TOReplication control statements. START REPLICA, STOP REPLICA, RESET REPLICA, CHANGE REPLICATION SOURCE TO.