MySQL: The Complete Reference

by Vikram Vaswani

Overview

Get comprehensive coverage of all the powerful new features of MySQL, one of the fastest--and free--relational databases in use today. Written in conjunction with the MySQL development team, this expert resource covers transactional integrity, disaster recovery, scalability, support for mobile users, Web-based and client/server programming, and much more.

Product Details

ISBN-13:	9780071782432
Publisher:	McGraw Hill LLC
Publication date:	01/08/2004
Series:	Osborne Complete Reference Series
Sold by:	Barnes & Noble
Format:	eBook
Pages:	544
File size:	42 MB
Note:	This product may take a few minutes to download.

About the Author

Vikram Vaswani is the founder and CEO of Melonfire (http://www.melonfire.com/), a company specializing in software consultancy and content creation and syndication services. He is also the author of PHP Programming Solutions, How to do Everything with PHP and MySQL, and MySQL: The Complete Reference (all McGraw-Hill/Osborne titles) and XML and PHP (New Riders Publishing). He is also the author of numerous well-received articles on open-source technologies (including Perl, Python, XML and the very popular PHP 101 series), all written with the goal of making complex technologies accessible and understandable to novice users. He has been developing software since 1995, was first introduced to PHP in 1998, and hasn't looked back since. He is regular columnist with Zend Technologies (creators of PHP), as well as with IBM DeveloperWorks, CNET Builder.com, DevX.com and other OSS sites.

Table of Contents

Part I: Installation 1: Introduction to Databases 2: A Technical Tour of MySQL 3: MySQL Installation and Configuration Part II: Usage 4: SQL Basics 5: MySQL Data Types 6: MySQL Operators 7: MySQL Functions 8: Working with Databases and Tables 9: Working with Data 10: Joins 11: Subqueries 12: Transactions Part III: Administration 13: Administration and Configuration 14: Security, Access Control, and Privileges 15: Maintenance, Backup, and Recovery 16: Performance Optimization 17: MySQL Replication Part IV: Development 18: The MySQL APIs 19: MySQL and C 20: MySQL and Perl 21: MySQL and PHP

Editorial Reviews

From the Computer Media column by Rachel Singer. Gordon. .

...perennially popular open-source companions for . creating database-driven web sites. These guides cover MySQL, as well as its use with PHP and other languages..."Complete Reference" tries to be all things to all people, covering topics from an introduction to relational databases and installing and configuring MySQL to reference material for administrators, but is most appropriate for new and intermediate users. Sidebars and notes add info and link to additional resources, while a welcome thoroughness and clarity make this a good, basic purchase for all libraries.

From the Computer Media column by Rachel Singer Gordon

...perennially popular open-source companions for creating database-driven web sites. These guides cover MySQL, as well as its use with PHP and other languages..."Complete Reference" tries to be all things to all people, covering topics from an introduction to relational databases and installing and configuring MySQL to reference material for administrators, but is most appropriate for new and intermediate users. Sidebars and notes add info and link to additional resources, while a welcome thoroughness and clarity make this a good, basic purchase for all libraries.

From the Publisher