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 Designer

The Ajax-based Designer offers a visually-driven way of managing relations (both internal and foreign key-based), and defining the display column for each table. It can also act as:

  • A menu to access the structure of existing tables and to access the table creation page
  • A PDF schema manager, if we want a PDF schema encompassing all our tables

On the Designer workspace, we can work on the relations for all tables on the same panel. On the other hand, the Relation view shows the relations for only a single table at a time.

We access this feature from the Database view by clicking on the Designer menu tab.

Note

If this menu tab does not appear, it's because we are yet to install the phpMyAdmin configuration storage ...

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