Defining relations with the relation view
After the installation of the phpMyAdmin configuration storage, there are more options available in the Database view and the Table view. We will now examine the Relation view link in the Structure page of the Table view.
This view is used to:
Define the relations of the current table with the other tables
Choose the display column
Our goal here is to create a relation between the book table (which contains the author ID) and the author table (which describes each author by an ID). We start on the Table view for the book table, go to Structure, and click on the Relation view link.
Defining internal relations
If the book table is in MyISAM format, we see the following screen (otherwise, the display would be different, as explained in the Defining foreign key relations section later):
This screen allows us to create Internal relation (stored in the pma_relation table) as MySQL itself does not have any relational notion for MyISAM tables. The empty drop-down...
