本文介绍了mysql错误"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;
谁能建议出什么问题了?
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"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！