Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to enable relation view in phpmyadmin

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:

enter image description here

However anytime when I create a table with my host phpmyadmin, I dont have the option to select "relation view" See below:

enter image description here

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.

like image 282
NeverPhased Avatar asked Dec 07 '11 18:12

NeverPhased


People also ask

How do I show relations in MySQL?

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';


1 Answers

Change your storage engine to InnoDB by going to Operation

like image 98
Harley Avatar answered Oct 01 '22 04:10

Harley