MySQL syntax error when creating a table with 2 foreign keys as primary key -


i keep getting 1064 error when run below query don't understand what's wrong it:

create table hashmkb_mangatracker.group_release (  group_id int not null,  release_id int not null,  primary key (group_id, release_id),  unique index (release_id, group_id),  foreign key (group_id) references group(id),  foreign key (release_id) references release(id) ) engine=innodb; 

the error:

#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'group(id), foreign key (release_id) references release(id) ) engine=innodb' @ line 7  

appreciate help.

group reserved keyword in mysql. same goes release. have add backticks around this:

create table hashmkb_mangatracker.group_release (  group_id int not null,  release_id int not null,  primary key (group_id, release_id),  unique index (release_id, group_id),  foreign key (group_id) references `group`(id),  foreign key (release_id) references `release`(id) ) engine=innodb; 

here list of reserved words: http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html


Comments