MySQL: The Complete Reference / Edition 1

MySQL: The Complete Reference / Edition 1

by Vikram Vaswani, Pamela Smith
     
 

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

Get the most out of the MySQL database server—today’s most popular open source database—with help from this definitive guide. Take advantage of MySQL’s cross-platform support, independent storage engines, advanced permissions and security

See more details below

Overview

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

Get the most out of the MySQL database server—today’s most popular open source database—with 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.

Read More

Product Details

ISBN-13:
9780072224771
Publisher:
McGraw-Hill Professional Publishing
Publication date:
12/28/2003
Series:
Osborne Complete Reference Series
Pages:
544
Sales rank:
1,090,924
Product dimensions:
7.40(w) x 9.10(h) x 1.27(d)

Table of Contents

Foreword
Acknowledgments
Introduction
Pt. IInstallation
1Introduction to Databases3
2A Technical Tour of MySQL13
3MySQL Installation and Configuration27
Pt. IIUsage
4SQL Basics55
5MySQL Data Types75
6MySQL Operators101
7MySQL Functions127
8Working with Databases and Tables173
9Working with Data213
10Joins249
11Subqueries269
12Transactions291
Pt. IIIAdministration319
13Administration and Configuration319
14Security, Access Control, and Privileges335
15Maintenance, Backup, and Recovery357
16Performance Optimization371
17MySQL Replication389
Pt. IVDevelopment
18The MySQL APIs401
19MySQL and C411
20MySQL and Perl445
21MySQL and PHP485
Index521

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >