| |
| |
| Preface | |
| |
| |
| |
| Introduction and Tutorials | |
| |
| |
| |
| Introduction to MySQL | |
| |
| |
| The Value of MySQL | |
| |
| |
| The MySQL Package | |
| |
| |
| Licensing | |
| |
| |
| Mailing Lists | |
| |
| |
| Books and Other Publications | |
| |
| |
| |
| Installing MySQL | |
| |
| |
| Choosing a Distribution | |
| |
| |
| Unix Source Distributions | |
| |
| |
| Unix Binary Distributions | |
| |
| |
| Linux RPM Distributions | |
| |
| |
| Macintosh OS X Distributions | |
| |
| |
| Novell NetWare Distributions | |
| |
| |
| Windows Distributions | |
| |
| |
| Postinstallation | |
| |
| |
| |
| 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 | |
| |
| |
| |
| SQL Statements and Functions | |
| |
| |
| |
| Security and User Statements and Functions | |
| |
| |
| Statements and Functions | |
| |
| |
| SQL Statements in Alphabetical Order | |
| |
| |
| Functions in Alphabetical Order | |
| |
| |
| |
| Database and Table Schema Statements | |
| |
| |
| Statements and Clauses in Alphabetical Order | |
| |
| |
| |
| Data Manipulation Statements and Functions | |
| |
| |
| Statements and Functions Grouped by Characteristics | |
| |
| |
| Statements and Clauses in Alphabetical Order | |
| |
| |
| Functions in Alphabetical Order | |
| |
| |
| |
| Table and Server Administration Statements and Functions | |
| |
| |
| Statements and Clauses in Alphabetical Order | |
| |
| |
| Functions in Alphabetical Order | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Stored Routines Statements | |
| |
| |
| Statements in Alphabetical Order | |
| |
| |
| |
| Aggregate Clauses, Aggregate Functions, and Subqueries | |
| |
| |
| Aggregate Functions in Alphabetical Order | |
| |
| |
| Subqueries | |
| |
| |
| |
| String Functions | |
| |
| |
| String Functions Grouped by Type | |
| |
| |
| String Functions in Alphabetical Order | |
| |
| |
| |
| Date and Time Functions | |
| |
| |
| Data and Time Functions Grouped by Type | |
| |
| |
| Date and Time Functions in Alphabetical Order | |
| |
| |
| |
| Mathematical Functions | |
| |
| |
| Functions in Alphabetical Order | |
| |
| |
| |
| Flow Control Functions | |
| |
| |
| Functions in Alphabetical Order | |
| |
| |
| |
| MySQL Server and Client Tools | |
| |
| |
| |
| MySQL Server and Client | |
| |
| |
| mysql Client | |
| |
| |
| mysqld Server | |
| |
| |
| mysqld_multi | |
| |
| |
| mysqld_safe | |
| |
| |
| |
| Command-Line Utilities | |
| |
| |
| |
| APIs and Connectors | |
| |
| |
| |
| CAPI | |
| |
| |
| Using C with MySQL | |
| |
| |
| Functions in Alphabetical Order | |
| |
| |
| C API Datatypes | |
| |
| |
| |
| Perl API | |
| |
| |
| Using Perl DBI with MySQL | |
| |
| |
| Perl DBI Reference | |
| |
| |
| Attributes for Handles | |
| |
| |
| |
| PHP API | |
| |
| |
| Using PHP with MySQL | |
| |
| |
| PHP MySQL Functions in Alphabetical Order | |
| |
| |
| |
| Appendixes | |
| |
| |
| |
| Data Types | |
| |
| |
| |
| Operators | |
| |
| |
| |
| Server and Environment Variables | |
| |
| |
| Index | |