When working in XAMPP with phpmyadmin, after creating a table I have the option to click "relation view" after clicking on the structure tab. See below:
However anytime when I create a table with my host phpmyadmin, I dont have the option to select "relation view" See below:
Is there anyway of enabling this? Currently I have to set up relationships in xampp and export to my host phpmyadmin for it to work.
To see foreign key relationships of a column: SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA. KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = 'db_name' AND REFERENCED_TABLE_NAME = 'table_name' AND REFERENCED_COLUMN_NAME = 'column_name';
Change your storage engine to InnoDB by going to Operation
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With