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
Post a Comment