Mastering MySQL 4

Ian Gilfillan

Language: English

Publisher: Wiley

Published: Jan 21, 2003

Description:

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

From the Back Cover

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

About the Author

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.