Mastering MySQL 4

Ian Gilfillan

762 pages, parution le 16/01/2003

Ajouter à une liste

Indisponible

Résumé

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

L'auteur - Ian Gilfillan

Ian Gilfillan is lead developer for South Africa's premier news portal, Independent Online. He also has developed and taught technical courses on MySQL, databases, programming, and Web development. The author of many articles on databases and programming and a developer of South Africa's first online grocery store, Ian has been working with MySQL since 1997.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sybex
Auteur(s)	Ian Gilfillan
Parution	16/01/2003
Nb. de pages	762
Format	19 x 22,8
Couverture	Broché
Poids	1218g
Intérieur	Noir et Blanc
EAN13	9780782141627
ISBN13	978-0-7821-4162-7