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 Designer

The Ajax-based Designer feature appeared in phpMyAdmin 2.10. It offers a mouse-driven way of managing relations (both internal and foreign key-based), and defining the display field 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 the Designer menu tab.

Note

If this menu tab does not appear, it's because we are yet to install 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