Table of Content

only for RuBoard - do not distribute or recompile

Managing and Using MySQL, 2nd Edition

Preface
     Audience
     Purpose
     Using This Book
     Conventions Used in This Book
     Comments and Questions
     Acknowledgments

I: Introduction

1. MySQL
     1.1 Relational Databases
     1.2 The History of MySQL
     1.3 MySQL Design
     1.4 MySQL Features
     1.5 MySQL Applications
     1.6 What You Get

2. Installation
     2.1 Preparation
     2.2 Unix Installation
     2.3 Windows Installation

3. SQL According to MySQL
     3.1 SQL Basics
     3.2 Database Creation
     3.3 Table Management
     3.4 MySQL Data Types
     3.5 Indexing
     3.6 Managing Data
     3.7 Queries
     3.8 SQL Operators
     3.9 Advanced Features

4. Database Administration
     4.1 Configuration
     4.2 Server Startup and Shutdown
     4.3 Logging
     4.4 Backup
     4.5 Recovery
     4.6 Table Maintenance and Crash Recovery

II: MySQL Administration

5. Performance Tuning
     5.1 An Approach to Performance Tuning
     5.2 Application Tuning
     5.3 Database Server Tuning
     5.4 Operating System/Hardware Tuning

6. Security
     6.1 Database Security
     6.2 System Security
     6.3 Application Security

7. Database Design
     7.1 Database Design Primer
     7.2 Normalization
     7.3 A Logical Data-Modeling Methodology
     7.4 Physical Database Design

III: MySQL Programming

8. Database Applications
     8.1 Architecture
     8.2 Connections and Transactions
     8.3 Object/Relational Modeling

9. Perl
     9.1 Introduction to DBI
     9.2 DBI and CGI
     9.3 A General Model for Maintainable Perl Programs

10. Python
     10.1 DB-API
     10.2 Proprietary Operations
     10.3 Applied DB-API

11. PHP
     11.1 Introducing PHP
     11.2 Installing PHP
     11.3 Accessing the MySQL DBMS with PHP
     11.4 Securing User Data
     11.5 Managing Sessions
     11.6 Writing Data with PHP
     11.7 Using the HTML <form> Environment
     11.8 Where to Find Out More

12. C API
     12.1 API Overview
     12.2 The C API in Practice
     12.3 Advanced Issues

13. Java
     13.1 The JDBC API
     13.2 Simple Database Access
     13.3 Dynamic Database Access
     13.4 A Guest Book Servlet

14. Extending MySQL
     14.1 User-Defined Functions
     14.2 Alternative Character Sets

IV: MySQL Reference

15. SQL Syntax for MySQL
     15.1 Basic Syntax
     15.2 SQL Commands

16. MySQL Data Types
     16.1 Numeric Data Types
     16.2 String Data Types
     16.3 Date Data Types
     16.4 Complex Data Types

17. Operators and Functions
     17.1 Operators
     17.2 Functions

18. MySQL PHP API Reference
     18.1 Data Types
     18.2 Functions

19. C Reference
     19.1 Data Types
     19.2 Functions

20. The Python DB-API
     20.1 Module: MySQLdb

Colophon

only for RuBoard - do not distribute or recompile