Managing & Using MySQL
Managing & Using MySQL, Second Edition Open Source SQL Databases for Managing Information & Web Sites By George Reese, Randy Jay Yarger, Tim King
With Hugh E. Williams
April 2002
Pages: 442

| Table of Contents | Index | Sample Chapter | Colophon

Table of Contents

  1. Introduction

    1. Chapter 1 MySQL

      1. Relational Databases
      2. The History of MySQL
      3. MySQL Design
      4. MySQL Features
      5. MySQL Applications
      6. What You Get

    2. Chapter 2 Installation

      1. Preparation
      2. Unix Installation
      3. Windows Installation

    3. Chapter 3 SQL According to MySQL

      1. SQL Basics
      2. Database Creation
      3. Table Management
      4. MySQL Data Types
      5. Indexing
      6. Managing Data
      7. Queries
      8. SQL Operators
      9. Advanced Features

    4. Chapter 4 Database Administration

      1. Configuration
      2. Server Startup and Shutdown
      3. Logging
      4. Backup
      5. Recovery
      6. Table Maintenance and Crash Recovery

  2. MySQL Administration

    1. Chapter 5 Performance Tuning

      1. An Approach to Performance Tuning
      2. Application Tuning
      3. Database Server Tuning
      4. Operating System/Hardware Tuning

    2. Chapter 6 Security

      1. Database Security
      2. System Security
      3. Application Security

    3. Chapter 7 Database Design

      1. Database Design Primer
      2. Normalization
      3. A Logical Data-Modeling Methodology
      4. Physical Database Design

  3. MySQL Programming

    1. Chapter 8 Database Applications

      1. Architecture
      2. Connections and Transactions
      3. Object/Relational Modeling

    2. Chapter 9 Perl

      1. Introduction to DBI
      2. DBI and CGI
      3. A General Model for Maintainable Perl Programs

    3. Chapter 10 Python

      1. DB-API
      2. Proprietary Operations
      3. Applied DB-API

    4. Chapter 11 PHP

      1. Introducing PHP
      2. Installing PHP
      3. Accessing the MySQL DBMS with PHP
      4. Securing User Data
      5. Managing Sessions
      6. Writing Data with PHP
      7. Using the HTML <form> Environment
      8. Where to Find Out More

    5. Chapter 12 C API

      1. API Overview
      2. The C API in Practice
      3. Advanced Issues

    6. Chapter 13 Java

      1. The JDBC API
      2. Simple Database Access
      3. Dynamic Database Access
      4. A Guest Book Servlet

    7. Chapter 14 Extending MySQL

      1. User-Defined Functions
      2. Alternative Character Sets

  4. MySQL Reference

    1. Chapter 15 SQL Syntax for MySQL

      1. Basic Syntax
      2. SQL Commands

    2. Chapter 16 MySQL Data Types

      1. Numeric Data Types
      2. String Data Types
      3. Date Data Types
      4. Complex Data Types

    3. Chapter 17 Operators and Functions

      1. Operators
      2. Functions

    4. Chapter 18 MySQL PHP API Reference

      1. Data Types
      2. Functions

    5. Chapter 19 C Reference

      1. Data Types
      2. Functions

    6. Chapter 20 The Python DB-API

      1. Module: MySQLdb

  1. Colophon

Return to Managing & Using MySQL