MySQL in a Nutshell

by Russell J. T. Dyer

Overview

MySQL is the world's most popular open source database. MySQL is designed for speed, power, and flexibility in mission-critical, heavy-use environments and modest applications as well. It's also surprisingly rich in features. If you're a database administrator or programmer you probably love the myriad of things MySQL can do, but sometimes wish there wasn't such a myriad of things to remember. With MySQL in a Nutshell by your keyboard, you can drill down into the full depth of MySQL's capabilities quickly and easily.MySQL in a Nutshell is the indispensable desktop reference to all MySQL functions. Programming language APIs for PHP, Perl, and C are covered, as well as all the popular MySQL utilities.This invaluable resource clearly documents the details that experienced users need to take full advantage of this powerful database management system. Better yet, this wealth of information is packed into the concise, comprehensive, and extraordinarily easy-to-use format for which the in a Nutshell guides are renowned.In addition to providing a thorough reference to MySQL statements and functions, the administrative utilities, and the most popular APIs, MySQL in a Nutshell includes several tutorial chapters to help newcomers get started. Moreover, each chapter covering an API begins with a brief tutorial so that, regardless of your level of experience in any given area, you will be able to understand and master unfamiliar territory.MySQL in a Nutshell distills all the vital MySQL details you need on a daily basis into one convenient, well-organized book. It will save you hundreds of hours of tedious research or trial and error and put the facts you need to truly tap MySQL's capabilities at your fingertips.

Product Details

ISBN-13:	9781449379063
Publisher:	O'Reilly Media, Incorporated
Publication date:	05/03/2005
Series:	In a Nutshell (O'Reilly)
Sold by:	Barnes & Noble
Format:	eBook
Pages:	352
File size:	3 MB

About the Author

Russell Dyer is a freelance writer and currently the Curriculum
Manager 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