How can we find out the storage engine used by a specific table in MySQL?

The following MySQL statement can find out the storage engine used by the "Student" table in the database named "tutorial" -

mysql> SELECT ENGINE FROM information_schema.TABLES
  -> WHERE TABLE_SCHEMA = 'tutorial'
  -> AND TABLE_NAME = 'Student';
+--------+
| ENGINE |
+--------+
| MyISAM |
+--------+
1 row in set (0.13 sec)

The above is the detailed content of How can we find out the storage engine used by a specific table in MySQL?. For more information, please follow other related articles on the PHP Chinese website!