Table of Contents

MySQL in a Nutshell
By Russell Dyer
...............................................
Publisher: O'Reilly
Pub Date: May 2005
ISBN: 0-596-00789-2
Pages: 352

Table of Contents  | Index  | Errata

---

		Dedication
		Copyright
		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
			Section 1.1.  The Value of MySQL
			Section 1.2.  The MySQL Package
			Section 1.3.  Licensing
			Section 1.4.  Mailing Lists
			Section 1.5.  Books and Other Publications
		Chapter 2.  Installing MySQL
			Section 2.1.  Choosing a Distribution
			Section 2.2.  Unix Source Distributions
			Section 2.3.  Unix Binary Distributions
			Section 2.4.  Linux RPM Distributions
			Section 2.5.  Macintosh OS X Distributions
			Section 2.6.  Novell NetWare Distributions
			Section 2.7.  Windows Distributions
			Section 2.8.  Postinstallation
		Chapter 3.  MySQL Basics
			Section 3.1.  The mysql Client
			Section 3.2.  Creating a Database and Tables
			Section 3.3.  Show Me
			Section 3.4.  Inserting Data
			Section 3.5.  Selecting Data
			Section 3.6.  Ordering, Limiting, and Grouping
			Section 3.7.  Analyzing and Manipulating Data
			Section 3.8.  Changing Data
			Section 3.9.  Deleting Data
			Section 3.10.  Searching Data
			Section 3.11.  Importing Data in Bulk
			Section 3.12.  Command-Line Interface
			Section 3.13.  Conclusion
		Chapter 4.  SQL Statements
			Section 4.1.  Statements Grouped by Type
			Section 4.2.  Statements and Clauses in Alphabetical Order
		Chapter 5.  String Functions
			Section 5.1.  String Functions Grouped by Type
			Section 5.2.  String Functions in Alphabetical Order
		Chapter 6.  Date and Time Functions
			Section 6.1.  Date and Time Functions Grouped by Type
			Section 6.2.  Date and Time Functions in Alphabetical Order
		Chapter 7.  Mathematical and Aggregate Functions
			Section 7.1.  Functions in Alphabetical Order
		Chapter 8.  Flow Control Functions
			Section 8.1.  Functions in Alphabetical Order
		Chapter 9.  Miscellaneous Functions
			Section 9.1.  Functions in Alphabetical Order
		Chapter 10.  MySQL Server and Client
			mysql
			mysqld
			mysqld_multi
			mysqld_safe
		Chapter 11.  Command-Line Utilities
			comp_err
			isamchk
			make_binary_distribution
			msql2mysql
			my_print_defaults
			myisamchk
			myisamlog
			myisampack
			mysqlaccess
			mysqladmin
			mysqlbinlog
			mysqlbug
			mysqlcheck
			mysqldump
			mysqldumpslow
			mysqlhotcopy
			mysqlimport
			mysqlshow
			perror
		Chapter 12.  Perl API
			Section 12.1.  Using Perl DBI with MySQL
			Section 12.2.  Perl DBI Method and Function Reference
			Section 12.3.  Attributes for Handles
		Chapter 13.  PHP API
			Section 13.1.  Using PHP with MySQL
			Section 13.2.  PHP MySQL Functions in Alphabetical Order
		Chapter 14.  C API
			Section 14.1.  Using C with MySQL
			Section 14.2.  Functions in Alphabetical Order
			Section 14.3.  C API Datatypes
		Appendix A.  Datatypes
			Section A.1.  Numeric Datatypes
			Section A.2.  Accurate Numeric Types
			Section A.3.  Approximate Numeric Datatypes
			Section A.4.  Date and Time Datatypes
			Section A.5.  String Datatypes
		Appendix B.  Operators
			Section B.1.  Arithmetic Operators
			Section B.2.  Relational Operators
			Section B.3.  Logical Operators
			Section B.4.  Bitwise Operators
		Appendix C.  Environment Variables
		Colophon
		Index