MySQL in a Nutshell

Dedication;
Preface;
The Purpose of This Book;
How This Book Is Organized;
Conventions Used in This Book;
Using Code Examples;
Request for Comments;
Safari Enabled;
Acknowledgments;
Chapter 1: Introduction to MySQL;
1.1 The Value of MySQL;
1.2 The MySQL Package;
1.3 Licensing;
1.4 Mailing Lists;
1.5 Books and Other Publications;
Chapter 2: Installing MySQL;
2.1 Choosing a Distribution;
2.2 Unix Source Distributions;
2.3 Unix Binary Distributions;
2.4 Linux RPM Distributions;
2.5 Macintosh OS X Distributions;
2.6 Novell NetWare Distributions;
2.7 Windows Distributions;
2.8 Postinstallation;
Chapter 3: MySQL Basics;
3.1 The mysql Client;
3.2 Creating a Database and Tables;
3.3 Show Me;
3.4 Inserting Data;
3.5 Selecting Data;
3.6 Ordering, Limiting, and Grouping;
3.7 Analyzing and Manipulating Data;
3.8 Changing Data;
3.9 Deleting Data;
3.10 Searching Data;
3.11 Importing Data in Bulk;
3.12 Command-Line Interface;
3.13 Conclusion;
Chapter 4: SQL Statements;
4.1 Statements Grouped by Type;
4.2 Statements and Clauses in Alphabetical Order;
Chapter 5: String Functions;
5.1 String Functions Grouped by Type;
5.2 String Functions in Alphabetical Order;
Chapter 6: Date and Time Functions;
6.1 Date and Time Functions Grouped by Type;
6.2 Date and Time Functions in Alphabetical Order;
Chapter 7: Mathematical and Aggregate Functions;
7.1 Functions in Alphabetical Order;
Chapter 8: Flow Control Functions;
8.1 Functions in Alphabetical Order;
Chapter 9: Miscellaneous Functions;
9.1 Functions in Alphabetical Order;
Chapter 10: MySQL Server and Client;
Chapter 11: Command-Line Utilities;
Chapter 12: Perl API;
12.1 Using Perl DBI with MySQL;
12.2 Perl DBI Method and Function Reference;
12.3 Attributes for Handles;
Chapter 13: PHP API;
13.1 Using PHP with MySQL;
13.2 PHP MySQL Functions in Alphabetical Order;
Chapter 14: C API;
14.1 Using C with MySQL;
14.2 Functions in Alphabetical Order;
14.3 C API Datatypes;
Appendix A: Datatypes;
A.1 Numeric Datatypes;
A.2 Accurate Numeric Types;
A.3 Approximate Numeric Datatypes;
A.4 Date and Time Datatypes;
A.5 String Datatypes;
Appendix B: Operators;
B.1 Arithmetic Operators;
B.2 Relational Operators;
B.3 Logical Operators;
B.4 Bitwise Operators;
Appendix C: Environment Variables;
Colophon;