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.
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 ...
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.
