MySQL 5.0 Reference Manual

MySQL 5.0

Table of contents

Table of Contents
Preface
General Information
- About This Manual
- Conventions Used in This Manual
- Overview of MySQL AB
- Overview of the MySQL Database Management System
- Overview of the MaxDB Database Management System
- MySQL Development Roadmap
  - What's New in MySQL 5.0
- MySQL Information Sources
- How to Report Bugs or Problems
- MySQL Standards Compliance
Installing and Upgrading MySQL
- General Installation Issues
- Standard MySQL Installation Using a Binary Distribution
- Installing MySQL on Windows
- Installing MySQL on Linux
- Installing MySQL on Mac OS X
- Installing MySQL on Solaris
- Installing MySQL on NetWare
- Installing MySQL on Other Unix-Like Systems
- MySQL Installation Using a Source Distribution
- Post-Installation Setup and Testing
- Upgrading MySQL
- Downgrading MySQL
  - Downgrading to MySQL 4.1
- Operating System-Specific Notes
- Perl Installation Notes
Tutorial
- Connecting to and Disconnecting from the Server
- Entering Queries
- Creating and Using a Database
- Getting Information About Databases and Tables
- Using mysql in Batch Mode
- Examples of Common Queries
- Queries from the Twin Project
  - Find All Non-distributed Twins
  - Show a Table of Twin Pair Status
- Using MySQL with Apache
Using MySQL Programs
- Overview of MySQL Programs
- Invoking MySQL Programs
- Specifying Program Options
Database Administration
- Overview of Server-Side Programs
- mysqld The MySQL Server
- The mysqld-max Extended MySQL Server
- MySQL Server Startup Programs
- mysqlmanager The MySQL Instance Manager
- Installation-Related Programs
  - mysql_fix_privilege_tables Upgrade MySQL System Tables
  - mysql_upgrade Check Tables for MySQL Upgrade
- General Security Issues
- The MySQL Access Privilege System
- MySQL User Account Management
- Backup and Recovery
- MySQL Localization and International Usage
- MySQL Server Logs
- Running Multiple MySQL Servers on the Same Machine
- The MySQL Query Cache
Replication
- Introduction to Replication
- Replication Implementation Overview
- Replication Implementation Details
- How to Set Up Replication
- Replication Compatibility Between MySQL Versions
- Upgrading a Replication Setup
  - Upgrading Replication to 5.0
- Replication Features and Known Problems
- Replication Startup Options
- How Servers Evaluate Replication Rules
- Replication FAQ
- Troubleshooting Replication
- How to Report Replication Bugs or Problems
- Auto-Increment in Multiple-Master Replication
Optimization
- Optimization Overview
- Optimizing SELECT and Other Statements
- Locking Issues
- Optimizing Database Structure
- Optimizing the MySQL Server
- Disk Issues
  - Using Symbolic Links
Client and Utility Programs
- Overview of Client and Utility Programs
- myisam_ftdump Display Full-Text Index information
- myisamchk MyISAM Table-Maintenance Utility
- myisamlog Display MyISAM Log File Contents
- myisampack Generate Compressed, Read-Only MyISAM Tables
- mysql The MySQL Command-Line Tool
- mysql_explain_log Use EXPLAIN on Statements in Query Log
- mysqlaccess Client for Checking Access Privileges
- mysqladmin Client for Administering a MySQL Server
- mysqlbinlog Utility for Processing Binary Log Files
- mysqlcheck A Table Maintenance and Repair Program
- mysqldump A Database Backup Program
- mysqlhotcopy A Database Backup Program
- mysqlimport A Data Import Program
- mysqlshow Display Database, Table, and Column Information
- mysql_zap Kill Processes That Match a Pattern
- perror Explain Error Codes
- replace A String-Replacement Utility
Language Structure
- Literal Values
- Database, Table, Index, Column, and Alias Names
  - Identifier Qualifiers
  - Identifier Case Sensitivity
- User-Defined Variables
- Comment Syntax
- Treatment of Reserved Words in MySQL
Character Set Support
- Character Sets and Collations in General
- Character Sets and Collations in MySQL
- Specifying Character Sets and Collations
- Connection Character Sets and Collations
- Collation Issues
- Operations Affected by Character Set Support
- Unicode Support
- UTF-8 for Metadata
- Character Sets and Collations That MySQL Supports
- FAQ: MySQL Chinese, Japanese, and Korean Character Sets
Data Types
- Data Type Overview
- Numeric Types
- Date and Time Types
- String Types
- Data Type Storage Requirements
- Choosing the Right Type for a Column
- Using Data Types from Other Database Engines
Functions and Operators
- Operators
- Control Flow Functions
- String Functions
  - String Comparison Functions
- Numeric Functions
  - Arithmetic Operators
  - Mathematical Functions
- Date and Time Functions
- What Calendar Is Used By MySQL?
- Full-Text Search Functions
- Cast Functions and Operators
- Other Functions
- Functions and Modifiers for Use with GROUP BY Clauses
SQL Statement Syntax
- Data Definition Statements
- Data Manipulation Statements
- MySQL Utility Statements
- MySQL Transactional and Locking Statements
- Database Administration Statements
- Replication Statements
  - SQL Statements for Controlling Master Servers
  - SQL Statements for Controlling Slave Servers
- SQL Syntax for Prepared Statements
Storage Engines and Table Types
- The MyISAM Storage Engine
- The InnoDB Storage Engine
- The MERGE Storage Engine
  - MERGE Table Problems
- The MEMORY (HEAP) Storage Engine
- The BDB (BerkeleyDB) Storage Engine
- The EXAMPLE Storage Engine
- The FEDERATED Storage Engine
- The ARCHIVE Storage Engine
- The CSV Storage Engine
- The BLACKHOLE Storage Engine
MySQL Cluster
- MySQL Cluster Overview
- Basic MySQL Cluster Concepts
  - MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
- Simple Multi-Computer How-To
- MySQL Cluster Configuration
- Upgrading and Downgrading MySQL Cluster
  - Performing a Rolling Restart of the Cluster
  - Cluster Upgrade and Downgrade Compatibility
- Process Management in MySQL Cluster
- Management of MySQL Cluster
- On-line Backup of MySQL Cluster
- Using High-Speed Interconnects with MySQL Cluster
  - Configuring MySQL Cluster to use SCI Sockets
  - Understanding the Impact of Cluster Interconnects
- Known Limitations of MySQL Cluster
- MySQL Cluster Development Roadmap
  - MySQL Cluster Changes in MySQL 5.0
  - MySQL 5.1 Development Roadmap for MySQL Cluster
- MySQL Cluster FAQ
- MySQL Cluster Glossary
Spatial Extensions
- Introduction to MySQL Spatial Support
- The OpenGIS Geometry Model
- Supported Spatial Data Formats
  - Well-Known Text (WKT) Format
  - Well-Known Binary (WKB) Format
- Creating a Spatially Enabled MySQL Database
- Analyzing Spatial Information
- Optimizing Spatial Analysis
  - Creating Spatial Indexes
  - Using a Spatial Index
- MySQL Conformance and Compatibility
Stored Procedures and Functions
- Stored Routines and the Grant Tables
- Stored Routine Syntax
- Stored Procedures, Functions, Triggers, and Replication: Frequently Asked Questions
- Binary Logging of Stored Routines and Triggers
Triggers
- CREATE TRIGGER Syntax
- DROP TRIGGER Syntax
- Using Triggers
Views
- ALTER VIEW Syntax
- CREATE VIEW Syntax
- DROP VIEW Syntax
The INFORMATION_SCHEMA Database
- The INFORMATION_SCHEMA SCHEMATA Table
- The INFORMATION_SCHEMA TABLES Table
- The INFORMATION_SCHEMA COLUMNS Table
- The INFORMATION_SCHEMA STATISTICS Table
- The INFORMATION_SCHEMA USER_PRIVILEGES Table
- The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- The INFORMATION_SCHEMA CHARACTER_SETS Table
- The INFORMATION_SCHEMA COLLATIONS Table
- The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- The INFORMATION_SCHEMA ROUTINES Table
- The INFORMATION_SCHEMA VIEWS Table
- The INFORMATION_SCHEMA TRIGGERS Table
- Other INFORMATION_SCHEMA Tables
- Extensions to SHOW Statements
Precision Math
- Types of Numeric Values
- DECIMAL Data Type Changes
- Expression Handling
- Rounding Behavior
- Precision Math Examples
APIs and Libraries
- libmysqld, the Embedded MySQL Server Library
- MySQL C API
- MySQL PHP API
  - Common Problems with MySQL and PHP
  - Enabling Both mysql and mysqli in PHP
- MySQL Perl API
- MySQL C++ API
  - Borland C++
- MySQL Python API
- MySQL Tcl API
- MySQL Eiffel Wrapper
- MySQL Program Development Utilities
  - msql2mysql Convert mSQL Programs for Use with MySQL
  - mysql_config Get Compile Options for Compiling Clients
Connectors
- MySQL Connector/ODBC
- Connector/NET
- MySQL Connector/J
- MySQL Connector/MXJ
- Connector/PHP
Extending MySQL
- MySQL Internals
  - MySQL Threads
  - MySQL Test Suite
- Adding New Functions to MySQL
- Adding New Procedures to MySQL
  - Procedure Analyse
  - Writing a Procedure
Problems and Common Errors
- How to Determine What Is Causing a Problem
- Common Errors When Using MySQL Programs
- Installation-Related Issues
  - Problems Linking to the MySQL Client Library
  - Problems with File Permissions
- Administration-Related Issues
- Query-Related Issues
- Optimizer-Related Issues
- Table Definition-Related Issues
- Known Issues in MySQL
  - Open Issues in MySQL
Error Codes and Messages
- Server Error Codes and Messages
- Client Error Codes and Messages
Credits
- Developers at MySQL AB
- Contributors to MySQL
- Documenters and translators
- Libraries used by and included with MySQL
- Packages that support MySQL
- Tools that were used to create MySQL
- Supporters of MySQL
MySQL Change History
- Changes in release 5.0.x (Production)
- Changes in MySQL Cluster
- MySQL Connector/ODBC (MyODBC) Change History
- MySQL Connector/NET Change History
- MySQL Connector/J Change History
Porting to Other Systems
- Debugging a MySQL Server
- Debugging a MySQL Client
- The DBUG Package
- Comments about RTS Threads
- Differences Between Thread Packages
Environment Variables
Regular Expressions
Limits in MySQL
- Limits of Joins
Feature Restrictions
- Restrictions on Stored Routines and Triggers
- Restrictions on Server-Side Cursors
- Restrictions on Subqueries
- Restrictions on Views
- Restrictions on XA Transactions
GNU General Public License
MySQL FLOSS License Exception