MySQL in a Nutshell

Completely revised for the latest version of the MySQL database, this book is a comprehensive reference to MySQL commands and programming information, including programming language interfaces and new features for version 5.1. This wealth of information is packed into a concise, comprehensive, and extraordinarily easy-to-use format for which O'Reilly Nutshell guides are renowned. It's written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL.

Russell Dyer is a freelance writer specializing in MySQL database software and is the editor of the MySQL Knowledge Base (http://www.mysql.com/network/knowledgebase.html). 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

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

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Summary

Author Biography

Table of Contents

Supplemental Materials