MYSQL BIBLE

• Organization: The book is divided into five parts: Getting Starated with MySQL and Relational Databases; Understanding SQL Through MySQL; MySQL Administration; MySQL Developer Guide; and Advanced and Specialized MySQL Topics.
• Comprehensive coverage: This Bible covers both beginning-level and advanced topics. Topics covered include: introduction to relational database management; installing and configuring MySQL on the Linux, Windows 2000, and Mac OS X operating systems; MySQL security; debugging and repairing MySQL databases and servers; MySQL performance tuning; and developing MySQL applications with Perl and PHP.
• Coverage of NuSphere MySQL: Due to the growing popularity of the NuSphere MySQL package, this book covers its enhancements and how to install and develop with NuSphere MySQL.
• Running database application: This book builds an e-commerce sample database application throughout to demonstrate concepts and topics.

ABOUT THE CD-ROM:
What's on the CD-ROM: The CD-ROM includes the latest version of MySQL (either Version 4.0 or 4.1); sample database application and code in the book; and PHP and Perl.

Steve Suehring (Stevens Point, Wisconsin) is currently a Systems Engineer at CoreComm, a 350,000-user Internet Provider. In addition to his other responsibilities, Steve maintains authentication infrastructure using MySQL as the database backend. Steve has built numerous applications with both the Oracle and MySQL databases. He is a Microsoft Certified Systems Engineer, Cisco Certified Design Associate, and Cisco Certified Network Professional. Steve has also written articles for Linux Magazine.

Preface.

Acknowledgments.

PART 1: Getting Started.

Chapter 1: Relational Database Management.

Chapter 2: Preparing for Installation

Chapter 3: Linux Installation.

Chapter 4: Windows Installation.

Chapter 5: Macintosh Installation.

Chapter 6: Starting MySQL.

Chapter 7: Database Concepts and Design.

PART II: SQL Essentials.

Chapter 8: Command Line Interface (CLI).

Chapter 9: SQL According to MySQL.

Chapter 10: Database and Data.

PART III: Administration.

Chapter 11: Server Configurations.

Chapter 12: Security.

Chapter 13: Debugging and Repairing Databases.

Chapter 14: Performance Tuning.

PART IV: Development.

Chapter 15: Perl Development.

Chapter 16: PHP Development.

Chapter 17: ODBC/JDBC.

PART V: Advanced Performance.

Chapter 18: Replication.

Chapter 19: Integration of Internet Services.

Chapter 20: NuSphere Enhanced MySQL.

PART VI: Appendixes.

Appendix A: Application Reference.

Appendix B: Language Reference.

Appendix C: Function and Operator Reference.

Appendix D: Datatype Reference.

Appendix E: Glossary.

Appendix F: About the CD-ROM.

Index.