-
Book Overview & Buying
-
Table Of Contents
Mastering phpMyAdmin 2.11 for Effective MySQL Management - Third Edition
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Overview of this book
PhpMyAdmin is a well known and popular open-source tool written in PHP intended to handle the administration of MySQL over the Internet. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, and manage keys on fields. While most MySQL developers use routine features of phpMyAdmin every day, few are aware of the power and potential of its advanced features. This book builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet of this legendary tool.
MySQL is the most popular open-source database, used by millions of developers and supporting numerous large dynamic websites and applications. MySQL acquired this wide popularity by virtue of its open-source nature, performance, reliability, robustness, and support for various platforms. This popularity has also been helped by the existence of phpMyAdmin, the industry-standard administration tool that makes database management easy for both the experienced developer and the novice.
The powerful graphical interface that it provides to MySQL has made phpMyAdmin an indispensable tool for MySQL and web developers. Every phpMyAdmin user can benefit from unlocking the full potential of this powerful application. Whether you are an experienced developer, system administrator, web designer, or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your databases.
Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface
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
