首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

MySql 增添外键出错

2012-09-16 
MySql 添加外键出错alter table t_game add constraint fk_game_developer foreign key DeveloperId refer

MySql 添加外键出错
alter table t_game add constraint fk_game_developer foreign key DeveloperId references t_developer(id);

出错:
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 'refer
ences t_developer(id)' at line 1

[解决办法]
alter table t_game add constraint fk_game_developer foreign key( DeveloperId) references t_developer(id);

热点排行