为何无法更改引擎？

Question

参见这里：

https://www.jb51.net/article/...

我更改引擎

mysql> alter table num  type = MyISAM;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'type = MyISAM' at line 1
mysql> alter table num  type = Myisam;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'type = Myisam' at line 1

这个表里面已经有数据了，不能这样修改吗？

Answer 1

ALTER TABLE num ENGINE=MYISAM