The Definitive Guide to MySQL, 2/e

Summary

This is the second edition of Kofler’s acclaimed MySQL book, updated and expanded to cover MySQL 4.0, the most recent production release of the popular Open Source database, which boasts more than four million users worldwide.

Like the first edition, this revision, which has been renamed as The Definitive Guide to MySQL, Second Edition to reflect the breadth and depth of Kofler’s coverage of the topic, provides a thorough introduction to the installation, configuration, implementation, and administration of MySQL. In addition, Kofler also demonstrates how MySQL can be used in conjunction with various other technologies to create database-driven Web sites, and gives practical advice on database design. Kofler also shows what’s coming up next in MySQL 4.1.

The Definitive Guide to MySQL, Second Edition, is an irreplaceable resource for MySQL novices and experts alike.

Table of Contents

Part I Introduction
Chapter 1: What Is MySQL?
Chapter 2: The Test Environment
Chapter 3: Introductory Example (An Opinion Poll)
Chapter 4: User Interfaces
Part II Fundamentals
Chapter 5: Database Design
Chapter 6: An Introduction to SQL
Chapter 7: SQL Recipes
Chapter 8: InnoDB Tables and Transactions
Chapter 9: Security
Chapter 10: Administration and Server Configuration
Part III Programming
Chapter 11: PHP: Fundamentals and Programming Techniques
Chapter 12: PHP: LibraryManagement
Chapter 13: PHP: Discussion Forum
Chapter 14: Perl
Chapter 15: Java, JSP, JDBC
Chapter 16: C and C++
Chapter 17: Visual Basic, C#, ODBC
Part IV Reference
Chapter 18: SQL Reference
Chapter 19: MySQL Tools
Chapter 20: API Reference
Part V Appendices
Appendix A Glossary
Appendix B MySQL 4.1
Appendix C Example Files
Appendix D Bibliography