56,678
社区成员
发帖
与我相关
我的任务
分享急！！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;
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;
...全文
请发表友善的回复…
发表回复
码无边 2015-10-10
- 打赏
- 举报
mysql新版本的是使用engine属性
旧版使用type
ACMAIN_CHM 2015-10-09
- 打赏
- 举报
新版本MYSQL改为 ENGINE = MyISAM
benluobo 2015-10-09
- 打赏
- 举报
type 改成 ENGINE
rucypli 2015-10-09
- 打赏
- 举报
engine=myisam
rick-he 2015-10-09
- 打赏
- 举报
the right syntax to use near 'TYPE=MyISAM'
错误提示：看下type附近错误，
type 改成 ENGINE
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that correspond