Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Benefits of the Defined Relations


In this section, we will look at the benefits that we can currently test; other benefits will be described in Chapter 13 (The Multi-Table Query Generator) and Chapter 15 (System Documentation). Some other benefits of the linked-tables infrastructure will appear in Chapter 14 (Bookmarks) and Chapter 16 (MIME-Based Transformations).

These benefits are available for both internal and InnoDB relations.

Foreign Key Information

Let's browse the book table by entering the Search sub-page 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:

The Drop-Down List of Foreign Keys

Going back to the book table, in Insert mode (or in Edit mode), we now see a drop-down list of the possible keys for each field...