MySQL is an Open Source relational database management system that continues to grow remarkably in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed Web sites and applications.

In MySQL, Paul DuBois provides a comprehensive guide to using MySQL effectively and productively. He describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic Web pages, to administering MySQL servers.

MySQL has been completely updated to cover MySQL 4 and has been thoroughly reviewed for completeness, clarity, and technical accuracy by some of the leading developers in the MySQL community.

Contents

• Getting Started with MySQL and SQL
• Working with Data in MySQL
• MySQL SQL Syntax and Use
• Query Optimization

• Introduction to MySQL Programming
• The MySQL C API
• The Perl DBI API
• The PHP API
• PHP Overview. Putting PHP to Work

• Introduction to MySQL Administration
• The MySQL Data Directory
• General MySQL Administration
• Security
• Database Backups, Maintenance, and Repair

• Appendix A. Obtaining and Installing Software
• Appendix B. Column Type Reference
• Appendix C. Operator and Function Reference
• Appendix D. SQL Syntax Reference
• Appendix E. MySQL Program Reference
• Appendix F. C API Reference
• Appendix G. Perl DBI API Reference
• Appendix H. PHP API Reference
• Appendix I. Internet Service Providers