• Author:
  • Gilfillan, Ian
• Subject:
  Business Applications
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  07/01/2003
• Price:
  $89.99
• <  Buy this book  >

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

Ian Gilfallan is an experienced programmer, trainer, and writer. He is lead developer at Independent Online, South Africa's premier news portal. He has developed and taught web programming courses and has written technical articles on MySQL and other database topics. He has worked with MySQL since its early days.

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.