SQL语法错误YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQL/**/createtablesdbadminroles(roleidintunsignednotnullAUTOINCREMENT,rolenamevarchar(100)notnull,rolememotextnotnull,disabledenum

Question

SQL 语法错误 You have an error in your SQL syntax; check the manual that corresponds to your MySQL
/**/
create table sdb_admin_roles
(
role_id int unsigned not null AUTO_INCREMENT,
role_name varchar(100) not null,
role_memo text not null,
disabled enum('true','false') not null default 'false',
primary key (role_id)
)
type = MyISAM DEFAULT CHARACTER SET utf8

Answer 1

这段sql在我本地的环境运行没问题,检查你的mysql版本是不是低了?