+612 9045 4394
MySQL in a Nutshell 2e : In a Nutshell - Russell Dyer

MySQL in a Nutshell 2e

In a Nutshell

Paperback Published: 6th May 2008
ISBN: 9780596514334
Number Of Pages: 564

Share This Book:


RRP $56.00
In Stock
Enter an Australian post code for delivery estimate

Earn 75 Qantas Points
on this Book

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.

Prefacep. xi
Introduction and Tutorials
Introduction to MySQLp. 3
The Value of MySQLp. 3
The MySQL Packagep. 4
Licensingp. 4
Mailing Listsp. 5
Books and Other Publicationsp. 6
Installing MySQLp. 7
Choosing a Distributionp. 7
Unix Source Distributionsp. 8
Unix Binary Distributionsp. 10
Linux RPM Distributionsp. 11
Macintosh OS X Distributionsp. 12
Novell NetWare Distributionsp. 14
Windows Distributionsp. 15
Postinstallationp. 16
MySQL Basicsp. 19
The mysql Clientp. 19
Creating a Database and Tablesp. 20
Show Mep. 23
Inserting Datap. 23
Selecting Datap. 24
Ordering, Limiting, and Groupingp. 25
Analyzing and Manipulating Datap. 27
Changing Datap. 29
Deleting Datap. 30
Searching Datap. 31
Importing Data in Bulkp. 32
Command-Line Interfacep. 34
Conclusionp. 35
SQL Statements and Functions
Security and User Statements and Functionsp. 39
Statements and Functionsp. 40
SQL Statements in Alphabetical Orderp. 40
Functions in Alphabetical Orderp. 50
Database and Table Schema Statementsp. 57
Statements and Clauses in Alphabetical Orderp. 57
Data Manipulation Statements and Functionsp. 113
Statements and Functions Grouped by Characteristicsp. 113
Statements and Clauses in Alphabetical Orderp. 114
Functions in Alphabetical Orderp. 152
Table and Server Administration Statements and Functionsp. 155
Statements and Clauses in Alphabetical Orderp. 155
Functions in Alphabetical Orderp. 172
Replication Statements and Functionsp. 175
Merits of Replicationp. 175
Replication Processp. 176
The Replication User Accountp. 183
Configuring the Serversp. 185
Copying Databases and Starting Replicationp. 187
Starting Replicationp. 189
Backups with Replicationp. 190
SQL Statements and Functions in Alphabetical Orderp. 191
Replication Statesp. 198
Stored Routines Statementsp. 203
Statements in Alphabetical Orderp. 203
Aggregate Clauses, Aggregate Functions, and Subqueriesp. 221
Aggregate Functions in Alphabetical Orderp. 221
Subqueriesp. 229
String Functionsp. 235
String Functions Grouped by Typep. 235
String Functions in Alphabetical Orderp. 236
Date and Time Functionsp. 263
Data and Time Functions Grouped by Typep. 264
Date and Time Functions in Alphabetical Orderp. 264
Mathematical Functionsp. 297
Functions in Alphabetical Orderp. 297
Flow Control Functionsp. 309
Functions in Alphabetical Orderp. 309
MySQL Server and Client Tools
MySQL Server and Clientp. 315
mysql Clientp. 315
mysqld Serverp. 321
mysqld_multip. 352
mysqld_safep. 354
Command-Line Utilitiesp. 357
APIs and Connectors
CAPIp. 405
Using C with MySQLp. 405
Functions in Alphabetical Orderp. 408
C API Datatypesp. 435
Perl APIp. 437
Using Perl DBI with MySQLp. 437
Perl DBI Referencep. 442
Attributes for Handlesp. 470
PHP APIp. 477
Using PHP with MySQLp. 477
PHP MySQL Functions in Alphabetical Orderp. 479
Data Typesp. 503
Operatorsp. 511
Server and Environment Variablesp. 517
Indexp. 519
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780596514334
ISBN-10: 0596514336
Series: In a Nutshell
Audience: General
Format: Paperback
Language: English
Number Of Pages: 564
Published: 6th May 2008
Publisher: John Wiley & Sons Publishers
Country of Publication: US
Dimensions (cm): 22.7 x 15.1  x 3.06
Weight (kg): 0.77
Edition Number: 2
Edition Type: Revised

Earn 75 Qantas Points
on this Book