In this chapter, we covered the installation of the necessary infrastructure for keeping special metadata (data about tables), and learned how to define relations between both InnoDB and non-InnoDB tables. We also examined the modified behavior of phpMyAdmin when relations are present, foreign keys, getting information from the table, the Designer feature, and column-commenting.
Mastering phpMyAdmin 2.11 for Effective MySQL Management
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
Free Chapter
Introducing phpMyAdmin
Installing phpMyAdmin
Interface Overview
First Steps
Changing Data
Changing Table Structures
Exporting Structure and Data
Importing Structure and Data
Searching Data
Table and Database Operations
The Relational System
Entering SQL Commands
The Multi-Table Query Generator
Bookmarks
System Documentation
MIME-Based Transformations
Character Sets and Collations
MySQL 5.0 Features
MySQL Server Administration
Customer Reviews