O'Reilly logo

Mastering phpMyAdmin 3.4 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 installation of the phpMyAdmin configuration storage, there are more options available in the Database view and the Table view. We will now examine the Relation view link in the Structure page 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 column

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

Defining internal relations ...

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