Chapter 1. Introduction to MySQL
The Value of MySQL
The MySQL Package
Licensing
Mailing Lists
Books and Other Publications
Chapter 2. Installing MySQL
Choosing a Distribution
Unix Source Distributions
Unix Binary Distributions
Linux RPM Distributions
Macintosh OS X Distributions
Novell NetWare Distributions
Windows Distributions
Postinstallation
Chapter 3. MySQL Basics
The mysql Client
Creating a Database and Tables
Show Me
Inserting Data
Selecting Data
Ordering, Limiting, and Grouping
Analyzing and Manipulating Data
Changing Data
Deleting Data
Searching Data
Importing Data in Bulk
Command-Line Interface
Conclusion
Part II. SQL Statements and Functions
Chapter 4. Security and User Statements and Functions
Statements and Functions
SQL Statements in Alphabetical Order
Functions in Alphabetical Order
Chapter 5. Database and Table Schema Statements
Statements and Clauses in Alphabetical Order
Chapter 6. Data Manipulation Statements and Functions
Statements and Functions Grouped by Characteristics
Statements and Clauses in Alphabetical Order
Functions in Alphabetical Order
Chapter 7. Table and Server Administration Statements and Functions
Statements and Clauses in Alphabetical Order
Functions in Alphabetical Order
Chapter 8. Replication Statements and Functions
Merits of Replication
Replication Process
The Replication User Account
Configuring the Servers
Copying Databases and Starting Replication
Starting Replication
Backups with Replication
SQL Statements and Functions in Alphabetical Order
Replication States
Chapter 9. Stored Routines Statements
Statements in Alphabetical Order
Chapter 10. Aggregate Clauses, Aggregate Functions, and Subqueries
Aggregate Functions in Alphabetical Order
Subqueries
Chapter 11. String Functions
String Functions Grouped by Type
String Functions in Alphabetical Order
Chapter 12. Date and Time Functions
Date and Time Functions Grouped by Type
Date and Time Functions in Alphabetical Order
Chapter 13. Mathematical Functions
Functions in Alphabetical Order
Chapter 14. Flow Control Functions
Functions in Alphabetical Order
Part III. MySQL Server and Client Tools
Chapter 15. MySQL Server and Client
mysql Client
mysqld Server
mysqld_multi
mysqld_safe
Chapter 16. Command-Line Utilities
Part IV. APIs and Connectors
Chapter 17. C API
Using C with MySQL
Functions in Alphabetical Order
C API Datatypes
Chapter 18. Perl API
Using Perl DBI with MySQL
Perl DBI Reference
Attributes for Handles
Chapter 19. PHP API
Using PHP with MySQL
Part V. Appendixes
A. Data Types
B. Operators
C. Server and Environment Variables
Index