MySQL 5.1 Reference Manual :: 20 INFORMATION_SCHEMA Tables :: 20.18 The INFORMATION_SCHEMA ENGINES Table
Section Navigation [Toggle]
- 20 INFORMATION_SCHEMA Tables
- 20.1 The INFORMATION_SCHEMA SCHEMATA Table
- 20.2 The INFORMATION_SCHEMA TABLES Table
- 20.3 The INFORMATION_SCHEMA COLUMNS Table
- 20.4 The INFORMATION_SCHEMA STATISTICS Table
- 20.5 The INFORMATION_SCHEMA USER_PRIVILEGES Table
- 20.6 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- 20.7 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- 20.8 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- 20.9 The INFORMATION_SCHEMA CHARACTER_SETS Table
- 20.10 The INFORMATION_SCHEMA COLLATIONS Table
- 20.11 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- 20.12 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- 20.13 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- 20.14 The INFORMATION_SCHEMA ROUTINES Table
- 20.15 The INFORMATION_SCHEMA VIEWS Table
- 20.16 The INFORMATION_SCHEMA TRIGGERS Table
- 20.17 The INFORMATION_SCHEMA PLUGINS Table
- 20.18 The INFORMATION_SCHEMA ENGINES Table
- 20.19 The INFORMATION_SCHEMA PARTITIONS Table
- 20.20 The INFORMATION_SCHEMA EVENTS Table
- 20.21 The INFORMATION_SCHEMA FILES Table
- 20.22 The INFORMATION_SCHEMA PROCESSLIST Table
- 20.23 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
- 20.24 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
- 20.25 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
- 20.26 The INFORMATION_SCHEMA PROFILING Table
- 20.27 Other INFORMATION_SCHEMA Tables
- 20.28 Extensions to SHOW Statements
The PLUGINS table provides
information about storage engines.
INFORMATION_SCHEMA
Name |
SHOW
Name |
Remarks |
ENGINE |
Engine |
MySQL extension |
SUPPORT |
Support |
MySQL extension |
COMMENT |
Comment |
MySQL extension |
TRANSACTIONS |
Transactions |
MySQL extension |
XA |
XA |
MySQL extension |
SAVEPOINTS |
Savepoints |
MySQL extension |
Notes:
The
ENGINEStable is a nonstandard table. It was added in MySQL 5.1.5.
See also Section 12.4.5.17, “SHOW ENGINES Syntax”.
User Comments
Add your own comment.