解决 MySQL 错误"TYPE=MyISAM"?
mysqlmysqli database更新于 2024/2/27 5:28:00
要修复此错误，只需将 TYPE 替换为 ENGINE。设置引擎的语法如下 −
ENGINE = MyISAM;
使用 TYPE 时会发生 MySQL 错误。让我们在创建表时看看相同的场景 −
mysql> create table Customers −> ( −> CustomerId int, −> CustomerName varchar(200) −> )TYPE = MyISAM;
错误如下 −
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = MyISAM' at line 5
要解决上述错误，请将 TYPE 替换为 ENGINE，如下所示−
mysql> create table Customers −> ( −> CustomerId int, −> CustomerName varchar(200) −> )ENGINE = MyISAM; Query OK, 0 rows affected (0.24 sec)
MySQL 中的“ENGINE = MyISAM”更新成功。
