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.

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

About the Author

Claude Seidman (Plantation, FL) is a computer developer, DBA, trainer, and published author. He has recently published SQL Server 2000 Data Mining Technical Reference (Microsoft Press, March 2001) and is a frequent contributor to SQL Server Magazine. Pamela Smith (Lawrencevill, NJ) experienced in all aspects of systems programming, including application and database design, data warehousing, data mining, object-oriented distributed systems and Database Architecture and Bioinformatics expertise. She has 15 years of experience in the IT industry, acquiring indepth knowledge of its practices and standards with a proven track record of implementation and delivery of large scale integrated distributed software systems.

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. Library Journal 20041201