MySQL :: MySQL 8.4 Reference Manual :: 17.1.3 Verifying that InnoDB is the Default Storage Engine

version 8.4

8.0 current
5.7

8.0 Japanese

MySQL 8.4 Reference Manual / ... / Verifying that InnoDB is the Default Storage Engine

使用SHOW ENGINES语句查看可用的 MySQL 存储引擎。查找DEFAULT在SUPPORT列中。

mysql> SHOW ENGINES;

或者，查询信息_schema中的ENGINES表。

mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES;

PREV HOME UP NEXT