mysql - 带有 create 语句的 InnoDb 事务

Question

事务中是否允许使用 CREATE TABLE tbl_name ..... 等 sql 语句。

例如:

begin;

CREATE TABLE .......;

sdfghjk;

rollback;

尽管事务中的语句失败并且最后回滚，表仍然被创建。如果事务中的语句失败，是否有办法阻止创建表？

Answer 1

事务中允许使用 DDL 语句，但通常不受事务影响。来自 MySQL 文档，了解什么可以回滚，什么不可以回滚:

Some statements cannot be rolled back. In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines.

You should design your transactions not to include such statements. If you issue a statement early in a transaction that cannot be rolled back, and then another statement later fails, the full effect of the transaction cannot be rolled back in such cases by issuing a ROLLBACK statement.

Source