mysql错误"TYPE = MyISAM" [英] mysql error 'TYPE=MyISAM'

问题描述

下面的查询中，我正在Ubuntu 12，MySQL 5.1版本中执行并收到上述错误:

Below query I'm executing in Ubuntu 12, MySQL 5.1 version and receiving error as mentioned:

CREATE TABLE mantis_config_table (
    config_id VARCHAR(64) NOT NULL,
    project_id INTEGER NOT NULL DEFAULT 0,
    user_id INTEGER NOT NULL DEFAULT 0,
    access_reqd INTEGER DEFAULT 0,
    type INTEGER DEFAULT 90,
    value LONGTEXT NOT NULL,
    PRIMARY KEY (config_id, project_id, user_id)
) TYPE=MyISAM;

您的SQL语法有错误；请查看与您的MySQL服务器版本相对应的手册，以获取在第9行的"TYPE = MyISAM"附近使用正确的语法

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 9

谁能建议出什么问题了?

Can anyone suggest what's wrong?

推荐答案

替换

TYPE=MyISAM

使用

ENGINE=MyISAM

问题是根据MySQL版本更新，"TYPE = MyISAM"应为"ENGINE = MyISAM"-简单的搜索/替换即可解决此问题.

The problem was "TYPE=MyISAM" which should be "ENGINE=MyISAM" as per MySQL version updates - a simple search / replace has fix it.

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