In this chapter, we have covered various aspects such as opening the query generator, choosing tables, entering column criteria, sorting and showing columns, and altering the number of criteria rows or columns. We also saw how to use the AND
and OR
operators to define relations between rows and columns, and how to use automatic joins between tables.
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