Books & Videos

Table of Contents

  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 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 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 Credits

    1. Developers at MySQL AB

    2. Contributors to MySQL

    3. Supporters to MySQL

  4. Appendix 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 Environment Variables

  6. Appendix MySQL Regular Expressions

  7. Colophon