New edition of the definitive, best-selling guide to using, programming, and administering MySQL 5.1
Paul DuBois is a writer, database administrator, and leader in the open source and MySQL communities. He has contributed to the online documentation for MySQL and is the author of MySQL and Perl for the Web (New Riders), MySQL Cookbook, Using csh
and tcsh, and Software Portability with imake (O’Reilly). He is currently a technical writer with the MySQL documentation team at Sun Microsystems.
Introduction
p. 1
General MySQL Use
Getting Started with MySQL
p. 13
Using SQL to Manage Data
p. 101
Data Types
p. 201
Stored Programs
p. 289
Query Optimization
p. 303
Using MySQL Programming Interfaces
Introduction to MySQL Programming
p. 341
Writing MySQL Programs Using C
p. 359
Writing MySQL Programs Using Perl DBI
p. 435
Writing MySQL Programs Using PHP
p. 527
MySQL Administration
Introduction to MySQL Administration
p. 579
The MySQL Data Directory
p. 585
General MySQL Administration
p. 609
Access Control and Security
p. 699
Database Maintenance, Backups, and Replication
p. 737
Appendixes
Obtaining and Installing Software
p. 777
Data Type Reference
p. 797
Operator and Function Reference
p. 813
System, Status, and User Variable Reference
p. 889
SQL Syntax Reference
p. 937
MySQL Program Reference
p. 1037
Note:Appendixes G, H, and I are located online and are accessible either by registering this book at informit.com/register or by visiting www.kitebird.com/mysql-book
C API Reference
p. 1121
Perl DBI API Reference
p. 1177
PHP API Reference
p. 1207
Index
p. 1225
Table of Contents provided by Publisher. 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.
Please wait while the item is added to your bag...
×
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description,
with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.