mysql建 表语句错误

create table user_role(uid int(11) not null comment "用户编号",
 rid int(11) not null comment "角色编号", 
 primary key(uid, rid), 
 key "FK_Reference_10" (rid), 
 constraint "FK_Reference_10" foreign key (rid) references role (id), 
 constraint "FK_Reference_13" foreign key (uid) references user (id)) 
 engine=InnoDB default charset=utf8;


慕圣7574856
浏览 783回答 1
1回答

慕圣7574856

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 '"FK_Reference_10" (rid), constraint "FK_Reference_10" foreign key (rid) referenc' at line 1
打开App,查看更多内容
随时随地看视频慕课网APP

相关分类

MySQL