Team LiB
Previous Section Next Section
Book Cover
• Table of Contents
• Index
MySQL™ The definitive guide to using, programming, and administering MySQL 4.1 and 5.0 Third Edition
By Paul DuBois
Publisher: Sams
Pub Date: March 08, 2005
ISBN: 0-672-32673-6
Pages: 1320

   About the Author
      Third Edition
      Second Edition
      First Edition
   Tell Us What You Think
      Why Choose MySQL?
      Already Running Another RDBMS?
      Tools Provided with MySQL
      What You Can Expect from This Book
      Road Map to This Book
      How to Read This Book
      Versions of Software Covered in This Book
      Conventions Used in This Book
      Additional Resources
    Chapter 1.  Getting Started with MySQL and SQL
      How MySQL Can Help You
      A Sample Database
      Basic Database Terminology
      A MySQL Tutorial
      Tips for Interacting with mysql
      Where to Now?
    Chapter 2.  MySQL SQL Syntax and Use
      MySQL Naming Rules
      The Server SQL Mode
      Character Set Support
      Selecting, Creating, Dropping, and Altering Databases
      Creating, Dropping, Indexing, and Altering Tables
      Getting Information About Databases and Tables
      Performing Multiple-Table Retrievals with Joins
      Performing Multiple-Table Retrievals with Subqueries
      Performing Multiple-Table Retrievals with UNION
      Multiple-Table Deletes and Updates
      Performing Transactions
      Foreign Keys and Referential Integrity
      Using FULLTEXT Searches
      New Features in MySQL 5.0
    Chapter 3.  Working with Data in MySQL
      Categories of Data Values
      MySQL Data Types
      How MySQL Handles Invalid Data Values
      Working with Sequences
      Choosing Data Types
      Expression Evaluation and Type Conversion
    Chapter 4.  Query Optimization
      Using Indexing
      The MySQL Query Optimizer
      Data Type Choices and Query Efficiency
      Loading Data Efficiently
      Scheduling and Locking Issues
      Optimization for Administrators
    Chapter 5.  Introduction to MySQL Programming
      Why Write Your Own MySQL Programs?
      APIs Available for MySQL
      Choosing an API
    Chapter 6.  Writing MySQL Programs Using C
      General Instructions for Building Client Programs
      Connecting to the Server
      Handling Errors and Processing Command Options
      Processing SQL Statements
      An Interactive Statement-Execution Program
      Writing Clients That Include SSL Support
      Using the Embedded Server Library
      Using Multiple-Statement Execution
      Using Server-Side Prepared Statements
    Chapter 7.  Writing MySQL Programs Using Perl DBI
      Perl Script Characteristics
      Perl DBI Overview
      Putting DBI to Work
      Using DBI in Web Applications
    Chapter 8.  Writing MySQL Programs Using PHP
      PHP Overview
      Putting PHP to Work
    Chapter 9.  Introduction to MySQL Administration
      Overview of Administrative Duties
      General Administration
      Database Repair and Maintenance
    Chapter 10.  The MySQL Data Directory
      Location of the Data Directory
      Structure of the Data Directory
      Relocating Data Directory Contents
    Chapter 11.  General MySQL Administration
      Securing a New MySQL Installation
      Arranging for MySQL Server Startup and Shutdown
      Managing MySQL User Accounts
      Maintaining Log Files
      Tuning the Server
      Storage Engine Configuration
      Controlling How the Server Listens for Connections
      Enabling or Disabling LOCAL Capability for LOAD DATA
      Configuring Backward Compatibility for Password Handling
      Internationalization and Localization Issues
      Running Multiple Servers
      Setting Up Replication Servers
      Updating MySQL
    Chapter 12.  MySQL and Security
      Internal Security: Preventing Unauthorized Filesystem Access
      External Security: Preventing Unauthorized Network Access
      Setting Up Secure Connections
    Chapter 13.  Database Backups, Maintenance, and Repair
      Performing Database Maintenance with the Server Running
      General Preventive Maintenance
      Making Database Backups
      Copying Databases to Another Server
      Checking and Repairing Database Tables
      Using Backups for Data Recovery
    Appendix A.  Obtaining and Installing Software
      Obtaining the sampdb Sample Database Distribution
      Obtaining MySQL and Related Software
      Choosing a Version of MySQL
      Installing MySQL on Unix
      Installing MySQL on Windows
    Appendix B.  Data Type Reference
      Numeric Types
      String Types
      Date and Time Types
      Spatial Types
    Appendix C.  Operator and Function Reference
    Appendix D.  System, Status, and User Variable Reference
      System Variables
      Session-Only System Variables
      Status Variables
      User-Defined Variables
    Appendix E.  SQL Syntax Reference
      SQL Statement Syntax
      Stored Routine Syntax
      Comment Syntax
    Appendix F.  MySQL Program Reference
      Specifying Program Options
    Appendix G.  C API Reference
      Compiling and Linking
      C API Data Types
      C API Functions
    Appendix H.  Perl DBI API Reference
      Writing Scripts
      DBI Methods
      DBI Utility Functions
      DBI Attributes
      DBI Environment Variables
    Appendix I.  PHP and PEAR DB API Reference
      Writing PHP Scripts
      PEAR DB Module Classes
      PEAR DB Module Methods

Team LiB
Previous Section Next Section