ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that c

1。ERROR 1064 (42000): 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 ')
engine=InnoDB
default character set=utf8 COMMENT '用户和部门关系表'' at line 15
 

 

2.将创建的数据表的最后一个字段后的逗号去掉即可。

eg：

create table `t_mis_user_role`(
`id` int(11) unsigned not null auto_increment comment '用户与角色关系id',
`userid` int(11) unsigned not null comment '用户id',
`roleid` int(11) unsigned not null comment '角色id',
`createtime` timestamp default current_timestamp comment '创建时间',
`updatetime` timestamp default current_timestamp on update current_timestamp null comment '更新时间',
primary key (`id`),
foreign key (`userid`) references `t_mis_user`(`id`),
foreign key (`roleid`) references `t_mis_role`(`id`),
)
engine=InnoDB
default character set=utf8 COMMENT '用户和角色关系表';

改为：create table `t_mis_user_role`(
`id` int(11) unsigned not null auto_increment comment '用户与角色关系id',
`userid` int(11) unsigned not null comment '用户id',
`roleid` int(11) unsigned not null comment '角色id',
`createtime` timestamp default current_timestamp comment '创建时间',
`updatetime` timestamp default current_timestamp on update current_timestamp null comment '更新时间',
primary key (`id`),
foreign key (`userid`) references `t_mis_user`(`id`),
foreign key (`roleid`) references `t_mis_role`(`id`)
)
engine=InnoDB
default character set=utf8 COMMENT '用户和角色关系表';