MySQL in a Nutshell: A Desktop Quick Reference

by Russell J. T. Dyer

Overview

When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book.

The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It's ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O'Reilly Nutshell references, it's easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL.

Inside, you'll find:

• A thorough reference to MySQL statements, functions, and administrative utilities
• Several tutorial chapters to help newcomers get started
• Programming language APIs for PHP, Perl, and C
• Brief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territory
• New chapters on replication, triggers, and stored procedures
• Plenty of new examples of how MySQL is used in practice
• Useful tips to help you get through the most difficult subjects

Whether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you're ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell has precisely what it takes.

Product Details

ISBN-13:	9781449379377
Publisher:	O'Reilly Media, Incorporated
Publication date:	04/15/2008
Series:	In a Nutshell (O'Reilly)
Sold by:	Barnes & Noble
Format:	eBook
Pages:	566
File size:	2 MB

About the Author

Russell Dyer is a freelance writer and currently the CurriculumManager at MariaDB Ab. He worked previously for six years at MySQL Ab. as their Knowledge Base Editor. He is the author of MySQL in a Nutshell (http://www.oreilly.com/catalog/mysqlian/) and has writen articles for several magazines: Dev Zone (a MySQL publication), Linux Journal, ONlamp.com, The Perl Journal, Red Hat Magazine, SysAdmin Magazine, Tech Republic, Unix Review, and XML.com. He has also finished his first novel, "In Search of Kafka". More information on Russell, along with a list of his published articles with links to them, can be found on his web site at http://russell.dyerhouse.com

Table of Contents

Preface     xi
Introduction and Tutorials
Introduction to MySQL     3
The Value of MySQL     3
The MySQL Package     4
Licensing     4
Mailing Lists     5
Books and Other Publications     6
Installing MySQL     7
Choosing a Distribution     7
Unix Source Distributions     8
Unix Binary Distributions     10
Linux RPM Distributions     11
Macintosh OS X Distributions     12
Novell NetWare Distributions     14
Windows Distributions     15
Postinstallation     16
MySQL Basics     19
The mysql Client     19
Creating a Database and Tables     20
Show Me     23
Inserting Data     23
Selecting Data     24
Ordering, Limiting, and Grouping     25
Analyzing and Manipulating Data     27
Changing Data     29
Deleting Data     30
Searching Data     31
Importing Data in Bulk     32
Command-Line Interface     34
Conclusion     35
SQL Statements and Functions
Security andUser Statements and Functions     39
Statements and Functions     40
SQL Statements in Alphabetical Order     40
Functions in Alphabetical Order     50
Database and Table Schema Statements     57
Statements and Clauses in Alphabetical Order     57
Data Manipulation Statements and Functions     113
Statements and Functions Grouped by Characteristics     113
Statements and Clauses in Alphabetical Order     114
Functions in Alphabetical Order     152
Table and Server Administration Statements and Functions     155
Statements and Clauses in Alphabetical Order     155
Functions in Alphabetical Order     172
Replication Statements and Functions     175
Merits of Replication     175
Replication Process     176
The Replication User Account     183
Configuring the Servers     185
Copying Databases and Starting Replication     187
Starting Replication     189
Backups with Replication     190
SQL Statements and Functions in Alphabetical Order     191
Replication States     198
Stored Routines Statements     203
Statements in Alphabetical Order      203
Aggregate Clauses, Aggregate Functions, and Subqueries     221
Aggregate Functions in Alphabetical Order     221
Subqueries     229
String Functions     235
String Functions Grouped by Type     235
String Functions in Alphabetical Order     236
Date and Time Functions     263
Data and Time Functions Grouped by Type     264
Date and Time Functions in Alphabetical Order     264
Mathematical Functions     297
Functions in Alphabetical Order     297
Flow Control Functions     309
Functions in Alphabetical Order     309
MySQL Server and Client Tools
MySQL Server and Client     315
mysql Client     315
mysqld Server     321
mysqld_multi     352
mysqld_safe     354
Command-Line Utilities     357
APIs and Connectors
CAPI     405
Using C with MySQL     405
Functions in Alphabetical Order     408
C API Datatypes     435
Perl API     437
Using Perl DBI with MySQL     437
Perl DBI Reference     442
Attributes for Handles     470
PHP API     477
Using PHP with MySQL     477
PHP MySQL Functions in Alphabetical Order     479
Appendixes
Data Types     503
Operators     511
Server and Environment Variables     517
Index     519