阅读背景:

将旧的MySQL代码迁移到新版本的MySQL。我在这里找不到涉及ENGINE = MyISAM的错误

来源:互联网 

Here is my error information :

这是我的错误信息:

CREATE TABLE `mb_topics` (
  `id` mediumint(9) NOT NULL auto_increment,
  `name` varchar(45) NOT NULL default '',
  `username` varchar(100) NOT NULL default '',
  `locked` char(1) NOT NULL default 'N',
  `boardid` smallint(6) NOT NULL default '0',
  `message` text NOT NULL,
  `postedon` varchar(50) NOT NULL default '',
  `lastpost` bigint(20) NOT NULL default '1',
  `message2` tinytext NOT NULL,
  `under` varchar(10) NOT NULL default '',
  `under2` int(6) NOT NULL default '0',
  `postbyid` int(8) NOT NULL default '0',
  `postedat` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 ;
[Err] 1064 - 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 **'(14) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISA' at line 20**
C



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: