The Difference Between MySQL and MySQL
How MySQL AB Operates
MySQL Core Values
MySQL Dual Licensing
Organization and Structure of the MySQL Reference Manual
The MySQL Mailing Lists

Major Program Components Used in MySQL
Major Operating System Families Supported by MySQL
Differences Between Major MySQL Distributions
Available MySQL Client Interfaces

Invoking Command-Line Client Programs
The mysql Client Program
Using mysqlimport
Using mysqldump
Checking Tables with mysqlcheck and myisamchk
Using MySQLCC
MySQL Connectivity Drivers

General Database and Table Properties
Storage Engines and Table Types
Limits on Number and Size of Database Components
Identifier Syntax
CREATE DATABASE and DROP DATABASE
CREATE TABLE
DROP TABLE
ALTER TABLE
Creating and Dropping Indexes
Column Types
Using SHOW and DESCRIBE to Review Table Structures

Identifying What Values to Display
Restricting a Selection Using WHERE
Using ORDER BY to Sort Query Results
Limiting a Selection Using LIMIT
Aggregate Functions, GROUP BY, and HAVING
Using DISTINCT to Eliminate Duplicates
Concatenating SELECT Results with UNION

Using SQL Expressions and Functions
Using LIKE for Pattern Matching
Using IN() to Test Membership in a List of Values
Case Sensitivity of Identifiers and Reserved Words
Using Reserved Words as Identifiers
NULL Values
Comments in SQL Statements

The INSERT and REPLACE Statements
The UPDATE Statement
The DELETE and TRUNCATE TABLE Statements

Writing Inner Joins
Writing Outer Joins
Converting Subqueries to Joins
Resolving Name Clashes Using Qualifiers and Aliases
Multiple-Table UPDATE and DELETE Statements

The LOAD DATA INFILE Statement
The SELECT … INTO OUTFILE Statement
Datafile Format Specifiers
Importing and Exporting NULL Values

Client/Server Overview
Choosing the Right Client
Connecting the Client to the Server
How MySQL Uses Disk Space
How MySQL Uses Memory
Log and Status Files
MySQL Storage Engines

Running MySQL on Windows
Running MySQL on Unix
Runtime MySQL Configuration
Compiling MySQL from a Source Distribution
Upgrading MySQL
Optimizing the Operating System for MySQL Use
Configuring Disks for MySQL Use
Choosing Hardware for MySQL Use

Securing MySQL
User Account Management
Client Access Control

Index Optimization and Index Usage
Using EXPLAIN to Analyze Queries
General Query Enhancement
Optimizing the Logical Database Structure

Special MyISAM Features
MyISAM-Specific Optimizations
MyISAM Locking Strategies
MyISAM Backup and Recovery
Checking and Repairing MyISAM Tables
MyISAM Table Maintenance

The InnoDB Tablespace and Logs
InnoDB Transaction Support
How InnoDB Uses Locks
InnoDB-Specific Optimizations
InnoDB Backup and Recovery
Checking and Repairing InnoDB Tables
InnoDB Maintenance

Interpreting mysqld Server Information
Tuning Memory Parameters
Using the Query Cache
Using Multiple Servers
Replication