读书人

MySql 增添外键出错

发布时间: 2012-09-16 17:33:16 作者: rapoo

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);

读书人网 >Mysql

热点推荐