Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

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 InnoDB-based—and of 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, whereas the Relation view shows the relations for 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 have yet to install the linked-tables infrastructure as described previously in this chapter, especially the designer_coords special table.

Interface Overview

The Designer page contains a main workspace where the tables can be seen. This workspace grows and shrinks dynamically, depending...