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 ...
Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
