鍍金池/ 問(wèn)答/數(shù)據(jù)庫(kù)/ 為何無(wú)法更改引擎？

為何無(wú)法更改引擎？

參見(jiàn)這里：

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

這個(gè)表里面已經(jīng)有數(shù)據(jù)了，不能這樣修改嗎？

回答
編輯回答
拼未來(lái)

ALTER TABLE num ENGINE=MYISAM

2017年11月5日 08:09