急！！ERROR 1064 (42000) at line 7: You have an error in your SQL syntax;

ERROR 1064 (42000) at line 7: 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 6

mysql语句

SET NAMES 'UTF8';

--
-- Table structure for table `cdef`
--

CREATE TABLE `cdef`(
  id mediumint(8) unsigned NOT NULL auto_increment,
  hash varchar(32) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

5 个解决方案

#1

engine=myisam

#2

type 改成 ENGINE

#3

the right syntax to use near 'TYPE=MyISAM'
错误提示：看下type附近错误，
type 改成 ENGINE

#4

新版本MYSQL改为 ENGINE = MyISAM

#5

mysql新版本的是使用engine属性
旧版使用type

#1