CREATE TABLE ...中的1064错误... TYPE = MYISAM [英] 1064 error in CREATE TABLE ... TYPE=MYISAM

问题描述

这是我的错误(如果您需要更多信息，请询问)- 错误 SQL查询:

Here is my error(if you need any more info just ask)- Error SQL query:

CREATE TABLE dave_bannedwords(

id INT( 11 ) NOT NULL AUTO_INCREMENT ,
word VARCHAR( 60 ) NOT NULL DEFAULT  '',
PRIMARY KEY ( id ) ,
KEY id( id )
) TYPE = MYISAM ;

MySQL说:

1064-您的SQL语法有错误；检查与您的MySQL服务器版本相对应的手册以使用正确的语法 在第6行的"TYPE = MyISAM"附近

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 'TYPE=MyISAM' at line 6

推荐答案

如 CREATE TABLE语法中所述:

As documented under CREATE TABLE Syntax:

注意
较早的TYPE选项与ENGINE是同义词. TYPE在MySQL 4.0中已弃用，在MySQL 5.5中已删除. 升级到MySQL 5.5或更高版本时，必须将依赖TYPE的现有应用程序转换为使用ENGINE.

Note
The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.

因此，您想要:

CREATE TABLE dave_bannedwords(
  id   INT(11)     NOT NULL AUTO_INCREMENT,
  word VARCHAR(60) NOT NULL DEFAULT '',
  PRIMARY KEY (id),
  KEY id(id) -- this is superfluous in the presence of your PK, ergo unnecessary
) ENGINE = MyISAM ;

这篇关于CREATE TABLE ...中的1064错误... TYPE = MYISAM的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！