Hello,
I am the user epiz_33179510 and my website is corella.epizy.com
I have a database with 2 tables, and when I want to create a foreign key from one table (the “deplacements” table to the “labyrinthes” table), there is blank fields when it is about choosing the database and the table to refer to.
I do use only InnoDB databases and utf-8_bin, but it doesn’t seem to change things…
Have You put the table’s index.
Fk need an index before you can select relations on phpmyadmin.
phpMyAdmin can sometimes be a bit funny to work with. If it’s giving you trouble, it’s also very easy to install Adminer on your own account and use that to manage your database instead.
4 Likes
Yes, I created two indexes on the two colomns I want to join, but it still doesn’t work…
I will try installing Adminer, like you said.
Hello,
I had the same problem and I managed to define the foreign key with using the “Designer” view at the database level. From this view, I used “New relation” and I could draw a link between the reference key in the first table and the (to be) foreign key in the second table. This resulted in the definition of a the second key as a foreign key.
Regards.
Thank you everyone. I tried with Adminer and it perfectly worked, I think it was phpMyAdmin that was capricious.
2 Likes
So. This topic has a solutions already.
But i just want to comment, how about the solution with design view. Is it work?
i mean not too fair to say a big software is capricious. Maybe, just maybe something new experiences just happen
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.