更新时间：2021-04-13 17:03:28
封面
版权页
Credits
About the Author
About the Reviewers
Preface
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Started with phpMyAdmin
Installing phpMyAdmin
Configuring phpMyAdmin
Upgrading phpMyAdmin
Summary
Chapter 2. Configuring Authentication and Security
Securing phpMyAdmin
Chapter 3. Over Viewing the Interface
Customizing general settings
Character sets collations and language
Navigation panel
Main panel
Query window
Chapter 4. Taking First Steps
Creating our first table
Inserting data manually
Browse mode
Creating an additional table
Chapter 5. Changing Data and Structure
Changing a table's structure
Chapter 6. Exporting Structure and Data (Backup)
Exporting a database
Exporting a table
Exporting selectively
Exporting multiple databases
Saving the export file on the server
Memory limits
Chapter 7. Importing Structure and Data
Importing SQL files
Importing CSV files
Importing other formats
Reading files from a web server upload directory
Displaying an upload progress bar
Displaying a character set dialog
Chapter 8. Searching Data
Single-table searches
Performing a complete database search
Chapter 9. Performing Table and Database Operations
Changing table attributes
Renaming moving and copying tables
Multi-table operations
Database operations
Chapter 10. Benefiting from the Relational System
Linked-tables infrastructure
Defining relations with the relation view
Defining relations with the Designer
Benefiting from the defined relations
Column-commenting
Chapter 11. Entering SQL Commands
The Query window
Multi-statement queries
Pretty printing (syntax-highlighting)
The SQL Validator
Chapter 12. Generating Multi-table Queries
Exploring column criteria
Generating automatic joins
Executing the query
Chapter 13. Synchronizing Data and Supporting Replication
Supporting MySQL replication
Chapter 14. Using Bookmarks
Creating bookmarks
Recalling bookmarks from the bookmarks list
Bookmark parameters
Executing bookmarks by browsing the pma_bookmark table
Chapter 15. Documenting the System
Generating relational schemas in PDF
Chapter 16. Transforming Data Using MIME
Enabling transformations
Examples of transformations
Chapter 17. Supporting MySQL 5.0 and 5.1
Supporting routines—stored procedures and functions
Executing code with triggers
Using information_schema
Profiling
