Mastering MySQL 4 / Edition 1

Mastering MySQL 4 / Edition 1

by Ian Gilfillan
     
 

ISBN-10: 0782141625

ISBN-13: 9780782141627

Pub. Date: 01/21/2003

Publisher: Wiley

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

Overview

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

Product Details

ISBN-13:
9780782141627
Publisher:
Wiley
Publication date:
01/21/2003
Pages:
772
Product dimensions:
7.50(w) x 9.25(h) x 1.49(d)

Table of 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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >