Phpmyadmin

[Lein1706]

Hi, I’m new here. i want to ask about my database. Why i can’t make a foreign key in my database ? please help me… thankyouu

[jaikrishna.t]

Hello @Lein1706, I see that you’re new here!

1. Please search the forum before creating a topic.
2. This might help:

Foreign keys without innodb

MyISAM does not support foreign keys, sadly. If you want to know why that is and how MySQL can still be called a relational database, that’s something only the MySQL developers can answer. But free hosting does not support any storage engine with support for foreign keys. So any foreign key consistencies will have to be enforced by the application code.

[Lein1706]

Sorry about that… and thankyou so much

[jaikrishna.t]

Feel free to mark my reply as the solution!

[Admin]

That post is out of date. As of the MySQL 5.7 upgrade a few months ago, we now have InnoDB which may also support foreign keys. But the reports are varied.

How are you trying to setup the foreign key and what do you see when trying to add it?

[Lein1706]

thanks for the info… But i think i can do it without foreign key so it’s not a problem. Thankyouu so muchh !!