Books & Videos

Table of Contents

  1. Chapter 1 Introduction to MySQL

    1. The Value of MySQL

    2. The MySQL Package

    3. Licensing

    4. Mailing Lists

    5. Books and Other Publications

  2. Chapter 2 Installing MySQL

    1. Choosing a Distribution

    2. Unix Source Distributions

    3. Unix Binary Distributions

    4. Linux RPM Distributions

    5. Macintosh OS X Distributions

    6. Novell NetWare Distributions

    7. Windows Distributions

    8. Postinstallation

  3. Chapter 3 MySQL Basics

    1. The mysql Client

    2. Creating a Database and Tables

    3. Show Me

    4. Inserting Data

    5. Selecting Data

    6. Ordering, Limiting, and Grouping

    7. Analyzing and Manipulating Data

    8. Changing Data

    9. Deleting Data

    10. Searching Data

    11. Importing Data in Bulk

    12. Command-Line Interface

    13. Conclusion

  4. Chapter 4 SQL Statements

    1. Statements Grouped by Type

    2. Statements and Clauses in Alphabetical Order

  5. Chapter 5 String Functions

    1. String Functions Grouped by Type

    2. String Functions in Alphabetical Order

  6. Chapter 6 Date and Time Functions

    1. Date and Time Functions Grouped by Type

    2. Date and Time Functions in Alphabetical Order

  7. Chapter 7 Mathematical and Aggregate Functions

    1. Functions in Alphabetical Order

  8. Chapter 8 Flow Control Functions

    1. Functions in Alphabetical Order

  9. Chapter 9 Miscellaneous Functions

    1. Functions in Alphabetical Order

  10. Chapter 10 MySQL Server and Client

  11. Chapter 11 Command-Line Utilities

  12. Chapter 12 Perl API

    1. Using Perl DBI with MySQL

    2. Perl DBI Method and Function Reference

    3. Attributes for Handles

  13. Chapter 13 PHP API

    1. Using PHP with MySQL

    2. PHP MySQL Functions in Alphabetical Order

  14. Chapter 14 C API

    1. Using C with MySQL

    2. Functions in Alphabetical Order

    3. C API Datatypes

  1. Appendix A Datatypes

    1. Numeric Datatypes

    2. Accurate Numeric Types

    3. Approximate Numeric Datatypes

    4. Date and Time Datatypes

    5. String Datatypes

  2. Appendix B Operators

    1. Arithmetic Operators

    2. Relational Operators

    3. Logical Operators

    4. Bitwise Operators

  3. Appendix C Environment Variables

  4. Colophon