MySQL: The Complete Reference

DESCRIPTION

The Most Authoritative Resource on the MySQL Database Available! Reviewed by the MySQL Development Team.

Get
the most out of the MySQL database servertoday's most popular open
source databasewith help from this definitive guide. Take advantage of
MySQL's cross-platform support, independent storage engines, advanced
permissions and security system, query caching, full-text indexing and
searching, and much more. Reviewed by the MySQL database development
team, MySQL: The Complete Reference explains in full detail how to use
this customizable RDMS to support robust, reliable, mission-critical
applications.

Install, configure, and test a MySQL database on
Linux/UNIX or Windows Use MySQL data types, statements, operators, and
functions Manage databases and tables with the Data Definition Language
(DDL) Add, delete, and query records using the Data Manipulation
Language (DML) Take advantage of transactional support Implement
MySQL's five-tiered access control and privilege system Handle database
optimization, backup, recovery, and replication Create applications in
C, C++, Perl, Java, PHP, and other languages Vikram Vaswani is the
founder and CEO of Melonfire, a company specializing in Web design,
development, and content creation for a variety of clients. He has also
written extensively on open source technologies, including MySQL, Perl,
Python, and PHP.

Table of Contents

Foreword
Acknowledgments
Introduction

Pt. I Installation
1 Introduction to Databases 3
2 A Technical Tour of MySQL 13
3 MySQL Installation and Configuration 27

Pt. II Usage
4 SQL Basics 55
5 MySQL Data Types 75
6 MySQL Operators 101
7 MySQL Functions 127
8 Working with Databases and Tables 173
9 Working with Data 213
10 Joins 249
11 Subqueries 269
12 Transactions 291

Pt. III Administration 319
13 Administration and Configuration 319
14 Security, Access Control, and Privileges 335
15 Maintenance, Backup, and Recovery 357
16 Performance Optimization 371
17 MySQL Replication 389

Pt. IV Development
18 The MySQL APIs 401
19 MySQL and C 411
20 MySQL and Perl 445
21 MySQL and PHP 485
Index 521