Name
SHOW ENGINES
Synopsis
SHOW [STORAGE] ENGINES
This statement will list the
table types or storage engines available for the version of MySQL
running on the server. It will state which are disabled on the server
and which are enabled, as well as which is the default type. It will
also provide comments on each type. The STORAGE
keyword is optional and has no effect on the results. This SQL
statement replaces SHOW TABLE TYPES
, which
produced the same results, but is deprecated.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.