O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Benefits of 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 chapters 13 and 15. Additional benefits of the linked-tables infrastructure will appear in chapters 14 and 16.

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

Foreign key information

Let's browse the book table by entering the Search subpage and choosing to display the first four columns. We see that the related key (author_id) is now a link. Moving the mouse pointer over any author_id value reveals the author's name (as defined by the display field of the author table).

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required