Benefiting from the defined relations

In this section, we will look at the benefits of the defined relations that we can currently test. Other benefits will be described in Chapter 12 and Chapter 15. Additional benefits of the phpMyAdmin configuration storage will appear in Chapter 14, Chapter 16, and Chapter 18.

These benefits are available for both internal and foreign key relations.

Foreign key information

Let us browse the book table. We see that the values of the related key (author_id) are now links. Moving the cursor over any author_id value reveals the author's name (as defined by the display column of the author table).

Clicking on the author_id brings us to the relevant table —author—for this specific author:

Instead of viewing the keys, we might prefer to see the display column for all the rows. Going back to the book table, we can select the Relational display column display option and click on Go. This produces a screen similar to the following screenshot:

We now switch back to viewing...