我无法在PHPmyadminXAMPP中设置外键-IcannotsetForeignkeyinPHPmyadminXAMPP

When i need to set a field as the foreign key in a table,in PHPMyAdmin. I am not getting it set right.

当我需要在PHPMyAdmin中将字段设置为表中的外键时。我没有把它弄好。

There is a Parent table called 'user' which has a primary key called 'uid'.I am using the 'uid' in the child table called 'student_register' as foreign key. But while setting it as foreign key constraint through the relation view link in phpmyadmin . i am not able to see the 'user' table in the drop down list to select it and set the 'uid' as foreign key .. I have sent the screen shot to get a clear picture. the screenshot for the phpmyadmin child table 'student_register'

有一个名为'user'的Parent表，它有一个名为'uid'的主键。我使用名为'student_register'的子表中的'uid'作为外键。但是通过phpmyadmin中的关系视图链接将其设置为外键约束。我无法在下拉列表中看到“用户”表格来选择它并将“uid”设置为外键..我已经发送了屏幕截图以获得清晰的图像。 phpmyadmin子表'student_register'的屏幕截图

2 个解决方案