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

Defining relations with the relation view

After the installing of the linked-tables infrastructure, there are now more options available in the Database view and the Table view. We will now examine a new link —Relation view—in the Structure subpage of the Table view.

Defining relations with the relation view

This view is used to:

  • Define the relations of the current table with the other tables
  • Choose the display field

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 the Relation view link.

Internal relations

As the ...

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