Can not able to set foreign key in mysql db using SqlYog

Question

Getting error while setting foreign key to table as shown in image.

Database Version: MySql 5.6

enter image description here

score 1 · Accepted Answer · edited May 23 '17 at 12:02

1

Change Engine to InnoDB

Check the difference between MyISAM and InnoDB here to make suitable decision for your database design

edited May 23 '17 at 12:02

Community

answered Mar 05 '16 at 07:47

mr. super cool

1 Answers1