MySQL 如何更改MySQL表的存储引擎？

MySQL ALTER TABLE语句可以按以下方式更改表的存储引擎-

mysql> ALTER TABLE Student ENGINE = 'InnoDB';
Query OK, 0 rows affected (0.90 sec)
Records: 0 Duplicates: 0 Warnings: 0

现在，通过以下语句的帮助，我们可以检查存储引擎是否已更改-

mysql> SELECT ENGINE FROM information_schema.TABLES
  -> WHERE TABLE_SCHEMA = 'tutorial'
  -> AND TABLE_NAME = 'Student';

+--------+
| ENGINE |
+--------+
| InnoDB |
+--------+
1 row in set (0.01 sec)

阅读更多：MySQL 教程