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;
1 回答
慕圣7574856
TA貢獻5條經(jīng)驗 獲得超0個贊
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
添加回答
舉報
0/150
提交
取消