1. Chapter 1 General Information

   1. About This Manual

   2. What Is MySQL?

   3. What Is MySQL AB?

   4. MySQL Support and Licensing

   5. MySQL 4.0 in a Nutshell

   6. MySQL Information Sources

   7. How Standards-Compatible Is MySQL?

   8. MySQL and the Future (the TODO)

   9. How MySQL Compares to Other Databases

2. Chapter 2 MySQL Installation

   1. Quick Standard Installation of MySQL

   2. General Installation Issues

   3. Installing a MySQL Source Distribution

   4. Post-Installation Setup and Testing

   5. Upgrading/Downgrading MySQL

   6. Operating System–Specific Notes

   7. Perl Installation Comments

3. Chapter 3 Tutorial Introduction

   1. Connecting to and Disconnecting from the Server

   2. Entering Queries

   3. Creating and Using a Database

   4. Getting Information About Databases and Tables

   5. Examples of Common Queries

   6. Using mysql in Batch Mode

   7. Queries from Twin Project

   8. Using MySQL with Apache

4. Chapter 4 Database Administration

   1. Configuring MySQL

   2. General Security Issues and the MySQL Access Privilege System

   3. MySQL User Account Management

   4. Disaster Prevention and Recovery

   5. Database Administration Language Reference

   6. MySQL Localisation and International Usage

   7. MySQL Server-Side Scripts and Utilities

   8. MySQL Client-Side Scripts and Utilities

   9. The MySQL Log Files

   10. Replication in MySQL

5. Chapter 5 MySQL Optimisation

   1. Optimisation Overview

   2. Optimising SELECTs and Other Queries

   3. Locking Issues

   4. Optimising Database Structure

   5. Optimising the MySQL Server

   6. Disk Issues

6. Chapter 6 MySQL Language Reference

   1. Language Structure

   2. Column Types

   3. Functions for Use in SELECT and WHERE Clauses

   4. Data Manipulation: SELECT, INSERT, UPDATE, DELETE

   5. Data Definition: CREATE, DROP, ALTER

   6. Basic MySQL User Utility Commands

   7. MySQL Transactional and Locking Commands

   8. MySQL Full-Text Search

   9. MySQL Query Cache

7. Chapter 7 MySQL Table Types

   1. MyISAM Tables

   2. MERGE Tables

   3. ISAM Tables

   4. HEAP Tables

   5. InnoDB Tables

   6. BDB or Berkeley_DB Tables

8. Chapter 8 MySQL APIs

   1. MySQL PHP API

   2. MySQL Perl API

   3. MySQL ODBC Support

   4. MySQL C API

   5. MySQL C++ APIs

   6. MySQL Java Connectivity (JDBC)

   7. MySQL Python APIs

   8. MySQL Tcl APIs

   9. MySQL Eiffel Wrapper

9. Chapter 9 Extending MySQL

   1. MySQL Internals

   2. Adding New Functions to MySQL

   3. Adding New Procedures to MySQL

1. Appendix A Problems and Common Errors

   1. How to Determine What Is Causing Problems

   2. Common Errors When Using MySQL

   3. Installation-Related Issues

   4. Administration-Related Issues

   5. Query-Related Issues

   6. Table Definition-Related Issues

2. Appendix B Contributed Programs

   1. APIs

   2. Clients

   3. Web Tools

   4. Performance Benchmarking Tool

   5. Authentication Tools

   6. Converters

   7. Using MySQL with Other Products

   8. Utilities

   9. RPMs for Common Tools (Most Are for RedHat 6.1)

   10. Useful Function

   11. Windows Program

   12. Uncategorized

3. Appendix C Credits

   1. Developers at MySQL AB

   2. Contributors to MySQL

   3. Supporters to MySQL

4. Appendix D Porting to Other Systems

   1. Debugging a MySQL Server

   2. Debugging a MySQL Client

   3. The DBUG Package

   4. Locking Methods

   5. Comments About RTS Threads

   6. Differences Between Different Thread Packages

5. Appendix E Environment Variables

6. Appendix F MySQL Regular Expressions

7. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. Jeffrey Holcomb was the production editor for MySQL Reference Manual. Audrey Doyle was the copyeditor. Jane Ellin provided quality assurance. Phil Dangler and David Chu provided production assistance. Michael "Monty" Widenius, David Axmark, and MySQL AB wrote the index.

Edie Freedman designed the cover of this book, with thanks to Hanna Dyer and Ellie Volckhausen. The cover image is a public domain engraving from The Clip Art Book, published in 1990 by Crescent Books. Emma Colby produced the cover layout with QuarkXPress 4.1, using Adobe's Formata and Helvetica fonts.

David Futato designed the interior layout. The print version of this book was created by translating the DocBook XML markup of its source files into a set of gtroff macros using a filter developed at O'Reilly & Associates by Norman Walsh. Steve Talbott designed and wrote the underlying macro set on the basis of the GNU troff --gs macros; Lenny Muellner adapted them to XML and implemented the book design. The GNU groff text formatter version 1.11.1 was used to generate PostScript output. The text and heading fonts are Times and Helvetica; the code font is Courier.