Ship-Ship-Hooray! FREE 2-Day Air* on $25+ Details >
Managing and Using MySQL : Open Source SQL Databases for Managing Information and Web Sites

Managing and Using MySQL : Open Source SQL Databases for Managing Information and Web Sites - 2nd edition

ISBN13: 978-0596002114

Cover of Managing and Using MySQL : Open Source SQL Databases for Managing Information and Web Sites 2ND 02 (ISBN 978-0596002114)
ISBN13: 978-0596002114
ISBN10: 0596002114

Cover type: Paperback
Edition: 2ND 02
Copyright: 2002
Publisher: O'Reilly Media, Inc.
Published: 2002
International: No

List price: $39.99

Managing and Using MySQL : Open Source SQL Databases for Managing Information and Web Sites - 2ND 02 edition

ISBN13: 978-0596002114

Randy J. Yarger, George Reese, Tim King and Hugh E. Williams

ISBN13: 978-0596002114
ISBN10: 0596002114

Cover type: Paperback
Edition: 2ND 02
Copyright: 2002
Publisher: O'Reilly Media, Inc.
Published: 2002
International: No

MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout.

This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions.

If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language.

Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.

Author Bio

Reese, George : digital@jwt

George Reese has taken an unusual path into business software development. After earning a B.A. in philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as The People's Court and ESPN's Up Close. The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems and the strategic role of technology in business processes. He is the author of Database Programming with JDBC and Java, 2nd Edition and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes a living as the National Practice Director of Technology Strategy for digital@jwt in Minneapolis.

Yarger, Randy J. : US Web/CKS

Randy J. Yarger is a senior solution developer at US Web/CKS in Southfield, Michigan. He combines expertise in database construction and interaction with extensive knowledge of the Internet to create world-class web applications. Randy has an uncanny knack of growing attached to computer systems that quickly become defunct. His first computer was a VIC-20, after which he moved on to the Commodore 64, then to several Amigas, and finally to a NeXTStation. He plans for his next box to be an Intel-based Linux system, but he's considering going Microsoft to save everyone some trouble. Randy lives in Ann Arbor, Michigan with his fiancée Stacie and cat Baci.

King, Tim :

Tim King has been working with computers since the early 1980s, when he programmed games on his Commodore 64 computer and founded a computer club in his high school. He earned a bachelor's degree in computer science from the University of Minnesota Institute of Technology in 1991. While there, he taught Unix and vi classes and was the leader of a rag-tag group of vi devotees called the "VI Zombies." Presently, Tim is a software consultant in San Francisco, CA, specializing in database and web technologies. His favorite activity is snowboarding, but he also enjoys photography and reading. You can reach him at

Williams, Hugh E. : RMIT University

Hugh Williams is a senior lecturer in the School of Computer Science and IT at RMIT University in Melbourne, Australia, where he has taught for seven years. He currently teaches in two areas: database technology and web technology, and is the coordinator of a Masters program that focuses on the Internet and the Web. His research interests include building better search engines, bioinformatics, and designing faster data structures. When not at work Hugh likes to go running, watch Richmond play footy, and follow the cricket. Hugh has a PhD from RMIT University.

Table of Contents


Part I. Introduction

1. MySQL
Relational Databases
The History of MySQL
MySQL Design
MySQL Features
MySQL Applications
What You Get

2. Installation
Unix Installation
Windows Installation

3. SQL According to MySQL
SQL Basics
Database Creation
Table Management
MySQL Data Types
Managing Data
SQL Operators
Advanced Features

4. Database Administration
Server Startup and Shutdown
Table Maintenance and Crash Recovery

Part II. MySQL Administration

5. Performance Tuning
An Approach to Performance Tuning
Application Tuning
Database Server Tuning
Operating System/Hardware Tuning

6. Security
Database Security
System Security
Application Security

7. Database Design
Database Design Primer
A Logical Data-Modeling Methodology
Physical Database Design

Part III. MySQL Programming

8. Database Applications
Connections and Transactions
Object/Relational Modeling

9. Perl
Introduction to DBI
A General Model for Maintainable Perl Programs

10. Python
Proprietary Operations
Applied DB-API

11. PHP
Introducing PHP
Installing PHP
Accessing the MySQL DBMS with PHP
Securing User Data
Managing Sessions
Writing Data with PHP
Using the HTML <form> Environment
Where to Find Out More

12. C API
API Overview
The C API in Practice
Advanced Issues

13. Java
Simple Database Access
Dynamic Database Access
A Guest Book Servlet

14. Extending MySQL
User-Defined Functions
Alternative Character Sets

Part IV. MySQL Reference

15. SQL Syntax for MySQL
Basic Syntax
SQL Commands

16. MySQL Data Types
Numeric Data Types
String Data Types
Date Data Types
Complex Data Types

17. Operators and Functions

18. MySQL PHP API Reference
Data Types

19. C Reference
Data types

20. The Python DB-API
Module: MySQLdb