MySQL 5.0 Reference Manual


This is the MySQL™ Reference Manual. It documents MySQL 5.0 through 5.0.96.

End of Product Lifecycle. Active development for MySQL Database Server version 5.0 has ended. Oracle offers various support offerings which may be of interest. For details and more information, see the MySQL section of the Lifetime Support Policy for Oracle Technology Products ( Please consider upgrading to a recent version.

MySQL 5.0 features. This manual describes features that are not included in every edition of MySQL 5.0; such features may not be included in the edition of MySQL 5.0 licensed to you. If you have any questions about the features included in your edition of MySQL 5.0, refer to your MySQL 5.0 license agreement or contact your Oracle representative.

For notes detailing the changes in each release, see the MySQL 5.0 Release Notes.

For legal information, see the Legal Notices.

For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users.

For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library.

Document generated on: 2016-01-21 (revision: 46178)

Table of Contents     [+/-]

Preface and Legal Notices
1 General Information     [+/-]
2 Installing and Upgrading MySQL     [+/-]
3 Tutorial     [+/-]
4 MySQL Programs     [+/-]
5 MySQL Server Administration     [+/-]
6 Security     [+/-]
7 Backup and Recovery     [+/-]
8 Optimization     [+/-]
9 Language Structure     [+/-]
10 Globalization     [+/-]
11 Data Types     [+/-]
12 Functions and Operators     [+/-]
13 SQL Statement Syntax     [+/-]
14 Storage Engines     [+/-]
15 High Availability and Scalability     [+/-]
16 Replication     [+/-]
17 MySQL Cluster     [+/-]
18 Stored Programs and Views     [+/-]
19 INFORMATION_SCHEMA Tables     [+/-]
20 Connectors and APIs     [+/-]
21 Extending MySQL     [+/-]
22 MySQL Enterprise Edition     [+/-]
A MySQL 5.0 Frequently Asked Questions     [+/-]
B Errors, Error Codes, and Common Problems     [+/-]
C Restrictions and Limits     [+/-]
D Licenses for Third-Party Components     [+/-]
General Index
C Function Index
Command Index
Function Index
Join Types Index
Operator Index
Option Index
Privileges Index
SQL Modes Index
Statement/Syntax Index
Status Variable Index
System Variable Index
Transaction Isolation Level Index