Mastering MySQL 4

MySQL Can Do More, and Now You Need to Know More

MySQL has proved it can compete with the big names in database management, such as SQL Server and Oracle, and with MySQL 4 this is truer than ever. Mastering MySQL 4 is your one-stop resource for all the information you need to create, maintain, use, and extend a MySQL database. It's also essential reading for anyone developing database applications in a MySQL environment. If you're new to MySQL, this is a great way to get up and running--fast. If you're upgrading, it will help you get all you can out of new features and support. Coverage includes:

• Installing MySQL
• Adding, removing, and updating records
• Choosing appropriate table types
• Choosing appropriate data types
• Optimizing MySQL queries
• Designing a database
• Normalizing table structure
• Maintaining and repairing databases
• Backing up and replicating data
• Managing user permissions and security
• Optimizing the MySQL server
• Extending MySQL
• Developing database applications

Contents

Part I Using MySQL

• Quickstart to MySQL
• Data Types and Table Types
• Advanced SQL
• Indexes and Query Optimization
• Programming with MySQL
• Extending MySQL

Part II Designing a Database

• Understanding Relational Databases
• Database Normalization
• Database Design

Part III MySQL Administration

• Basic Administration
• Database Backups
• Database Replication
• Configuring and Optimizing MySQL
• Database Security
• Installing MySQL
• Multiple Drives

Appendixes

• Appendix A MySQL Syntax Reference
• Appendix B MySQL Function and Operator Reference
• Appendix C PHP API
• Appendix D Perl DBI
• Appendix E Python Database API
• Appendix F Java API
• Appendix G C API
• Appendix H ODBC and .NET