innodb-隐式提交

隐式提交

1.DDL语句或者修改数据库对象的语句

Data definition language (DDL) statements that define or modify database objects.
例如:
ALTER DATABASE … UPGRADE DATA DIRECTORY NAME, ALTER EVENT, ALTER PROCEDURE, ALTER SERVER, ALTER TABLE, ALTER VIEW, CREATE DATABASE, CREATE EVENT, CREATE INDEX, CREATE PROCEDURE, CREATE SERVER, CREATE TABLE, CREATE TRIGGER, CREATE VIEW, DROP DATABASE, DROP EVENT, DROP INDEX, DROP PROCEDURE, DROP SERVER, DROP TABLE, DROP TRIGGER, DROP VIEW, RENAME TABLE, TRUNCATE TABLE.

创建表语句是在一个单独的事务中，因此用户不能通过rollback来回滚该事务。

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会导致一个隐式提交，但是create temporary table select不会导致一个隐式提交。

CREAT