Mastering MySQL 4 (Paperback)

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

Introduction

Part I • Using MySQL
Chapter 1 • Quickstart to MySQL
Chapter 2 • Data Types and Table Types
Chapter 3 • Advanced SQL
Chapter 4 • Indexes and Query Optimization
Chapter 5 • Programming with MySQL
Chapter 6 • Extending MySQL

Part II • Designing a Database
Chapter 7 • Understanding Relational Databases
Chapter 8 • Database Normalization
Chapter 9 • Database Design

Part III • MySQL Administration
Chapter 10 • Basic Administration
Chapter 11 • Database Backups
Chapter 12 • Database Replication
Chapter 13 • Configuring and Optimizing MySQL
Chapter 14 • Database Security
Chapter 15 • Installing MySQL
Chapter 16 • 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

Index