| CARVIEW |
Select Language
HTTP/2 302
server: nginx
date: Mon, 22 Dec 2025 16:37:58 GMT
content-type: text/plain; charset=utf-8
content-length: 0
x-archive-redirect-reason: found capture at 20090129161722
location: https://web.archive.org/web/20090129161722/https://dev.mysql.com/doc/
server-timing: captures_list;dur=1.071160, exclusion.robots;dur=0.067580, exclusion.robots.policy;dur=0.048742, esindex;dur=0.019307, cdx.remote;dur=8.026425, LoadShardBlock;dur=174.038808, PetaboxLoader3.datanode;dur=116.010277, PetaboxLoader3.resolve;dur=25.002629
x-app-server: wwwb-app210-dc8
x-ts: 302
x-tr: 247
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0
set-cookie: wb-p-SERVER=wwwb-app210; path=/
x-location: All
x-as: 14061
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
HTTP/2 200
server: nginx
date: Mon, 22 Dec 2025 16:37:59 GMT
content-type: text/html
x-archive-orig-date: Thu, 29 Jan 2009 16:17:21 GMT
x-archive-orig-server: Apache/2.0.58 (Unix) mod_ssl/2.0.58 OpenSSL/0.9.7f
x-archive-orig-set-cookie: MySQL_S=a4uk6lma1fncp1mr48msqpjalameso7h; path=/; domain=mysql.com
x-archive-orig-expires: Thu, 19 Nov 1981 08:52:00 GMT
x-archive-orig-cache-control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
x-archive-orig-pragma: no-cache
x-archive-orig-connection: close
x-archive-guessed-content-type: text/html
x-archive-guessed-charset: utf-8
memento-datetime: Thu, 29 Jan 2009 16:17:22 GMT
link: MySQL :: MySQL Documentation
Skip navigation links
Recommended Servers for MySQLThe world's most popular open source database
MySQL Enterprise
Related pages:
MySQL Documentation
The MySQL Reference Manual covers most areas of MySQL use. This manual is for both MySQL Community Server and MySQL Enterprise Server. If you cannot find the answer(s) from the manual, you can get support by purchasing MySQL Enterprise, which provides comprehensive support and services. MySQL Enterprise also provides a comprehensive knowledge base library that includes hundreds of technical articles resolving difficult problems on popular database topics such as performance, replication, and migration. Learn more about MySQL Enterprise »
You can also find help by visiting the MySQL Forums or by browsing our mailing list archives.
If you have trouble using downloaded CHM files, try this tip. If you have trouble using downloaded PDF files, try this tip. For instructions on using the Eclipse documentation plugin, see this tip.
Skip to: MySQL Reference Manual | MySQL Cluster Reference Guides | GUI Tools | MysQL Enterprise | Expert Guides | Help Tables | Examples | Meta Documentation | Community Contributed Documentation | Printed Books | Additional Resources
Language Filter: All | Chinese | English | French | German | Greek | Italian | Japanese | Portuguese | Russian | Spanish | Ukrainian
Browse MySQL Documentation by Topic
This table provides excerpts from or direct links to the MySQL Reference Manual, focusing on the information needs of specific target groups. Most excerpts are taken from the 5.1 Manual, unless otherwise noted. For product versions other than MySQL 5.1, and more formats, including downloadable HTML and PDF, see Topic Guides.MySQL Reference Manual
| MySQL Version | HTML Online | HTML Page/chapter | HTML Single page | Eclipse Doc Plugin | CHM | Man Pages | RPM | |||
| English | v3.23, v4.0, v4.1 | View | TGZ | Zip | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | TGZ | Zip | HTML | PDF | |
| English | v5.0 | View | TGZ | Zip | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | TGZ | Zip | HTML | PDF | |
| English | v5.1 (includes MySQL Cluster NDB 6.x) | View | TGZ | Zip | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | TGZ | Zip | HTML | PDF | |
| English | v5.1 (Maria) | View | TGZ | Zip | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | TGZ | Zip | HTML | PDF | |
| English | v6.0 | View | TGZ | Zip | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | TGZ | Zip | HTML | PDF | |
| Chinese | v5.1 | View | TGZ | Zip | |||||||
| German | v4.0 | TGZ | Zip | A4 | CHM | ||||||
| German | v5.1 | View | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | HTML | PDF | |||
| French | v5.0 | View | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | ||||
| Japanese | v4.1 | View | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | ||||
| Japanese | v5.1 | View | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | ||||
| Portuguese | v4.1 | View | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | ||||
| Russian | v4.0 | TGZ | Zip | TGZ | Zip | |||||||
| Spanish | v5.0 | View | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM | HTML | PDF |
MySQL Cluster Reference Guides
| HTML Online | HTML Page/chapter | HTML Single page | |||
| English | MySQL Cluster NDB 6.X Reference Guide | View | TGZ | Zip | TGZ | Zip | US Ltr | A4 |
| English | MySQL Cluster API Developer Guide | View | TGZ | Zip | US Ltr | A4 |
MySQL GUI Tools
| HTML Online | CHM | RPM | |||
| English | MySQL GUI Tools Book | US Ltr | A4 | HTML | PDF | ||
| Provides a single guide to all the applications in the GUI Tools suite | |||||
| English | MySQL Administrator | View | US Ltr | A4 | CHM | |
| English | MySQL Query Browser | View | US Ltr | A4 | CHM | |
| English | MySQL Migration Toolkit | View | US Ltr | A4 | CHM | |
| English | MySQL Workbench | View | US Ltr | A4 | CHM | |
| Greek | MySQL Query Browser | View | |||
| Italian | MySQL Administrator | View | US Ltr | A4 | CHM | |
| Italian | MySQL Query Browser | View | US Ltr | A4 | CHM | |
| Portuguese | MySQL Administrator | View | US Ltr | A4 | CHM | |
| Portuguese | MySQL Query Browser | View | US Ltr | A4 | CHM | |
| Russian | MySQL Query Browser | View | |||
| Spanish | MySQL Query Browser | View | US Ltr | A4 | CHM | |
| Ukrainian | MySQL Administrator | View | US Ltr | A4 | ||
MySQL Enterprise Documentation
| HTML Online | HTML Page/chapter | HTML Single page | CHM | ||||
| English | MySQL Enterprise Monitor | 2.0 | View | TGZ | Zip | TGZ | Zip | US Ltr | A4 | CHM |
Expert Guides
| HTML Online | CHM | |||
| English | MySQL Internals | View | ||
| English | MySQL Test Framework | View | US Ltr | A4 | CHM |
MySQL Help Tables
| Download | |
| MySQL v4.1 | Gzip | Zip |
| MySQL v5.0 | Gzip | Zip |
| MySQL v5.1 | Gzip | Zip |
| MySQL v6.0 | Gzip | Zip |
To use: Download, uncompress, then load into MySQL with this command: mysql mysql < file_name
Example Databases
Meta Documentation
| HTML Online | HTML Page/chapter | CHM | ||
| Guide to MySQL Documentation | View | TGZ | Zip | US Ltr | A4 | CHM |
| MySQL Documentation Formatting Guide | TGZ | Zip | US Ltr | A4 | CHM | |
| MySQL Documentation Style Guide | TGZ | Zip | US Ltr | A4 | CHM |
Community Contributed Documentation
| HTML Online | |
| MySQL User Guide | View |
Printed Books
- MySQL 5.1 Cluster Certification Study Guide (second edition, June 2008)
- Das offizielle MySQL 5-Handbuch (German, November 2006)
- MySQL Reference Manual, second edition (April 2006)
- MySQL 5.0 Certification Study Guide (August 2005)
- More books published by MySQL Press ...
Additional Resources
- ThoutReader™ format
- Technical articles about MySQL
- Whitepapers
- Press releases and business-related articles about MySQL
- Technical presentations about MySQL
- MySQL Mailing List Archives
Topic Guides
The following tables provide excerpts from or direct links to the MySQL Reference Manual, focusing on the information needs of specific target groups. Excerpts are available from the MySQL 5.0, MySQL 5.1 and MySQL 6.0 manuals. For sections that are already available as a complete section of the existing manual are available online, or by downloading the appropriate full manual.Getting Started
| Tutorial | HTML Online | ||
| English | Tutorial | 5.0 | View |
| English | Tutorial | 5.1 | View |
| English | Tutorial | 6.0 | View |
| English | Installation | 5.0 | View |
| English | Installation | 5.1 | View |
| English | Installation | 6.0 | View |
| English | Upgrading | 5.0 | View |
| English | Upgrading | 5.1 | View |
| English | Upgrading | 6.0 | View |
| English | Server Administration | 5.0 | View |
| English | Server Administration | 5.1 | View |
| English | Server Administration | 6.0 | View |
| English | Storage Engines | 5.0 | View |
| English | Storage Engines | 5.1 | View |
| English | Storage Engines | 6.0 | View |
| English | FAQs | 5.0 | View |
| English | FAQs | 5.1 | View |
| English | FAQs | 6.0 | View |
Platforms
| MySQL Version | HTML Online | HTML Page/chapter | |||
| English | Linux/Unix | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Linux/Unix | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Linux/Unix | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Mac OS X | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Mac OS X | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Mac OS X | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Windows | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Windows | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Windows | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Solaris | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Solaris | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Solaris | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Building from Source | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Building from Source | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Building from Source | 6.0 | View | TGZ | Zip | US Ltr | A4 |
Administrators
| MySQL Version | HTML Online | HTML Page/chapter | |||
| English | MySQL Version Reference | View | TGZ | Zip | US Ltr | A4 | |
| English | Security | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Security | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Security | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL Enterprise Monitor | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL Enterprise Monitor | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL Enterprise Monitor | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Startup/Shutdown | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Startup/Shutdown | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Startup/Shutdown | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Partitioning | 5.1 | View | ||
| English | Partitioning | 6.0 | View | ||
| English | Backup and Recovery | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Backup and Recovery | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Backup and Recovery | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Information Schema | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Information Schema | 6.0 | View | TGZ | Zip | US Ltr | A4 |
Developers
| MySQL Version | HTML Online | HTML Page/chapter | |||
| English | MySQL Version Reference | View | TGZ | Zip | US Ltr | A4 | |
| English | SQL Syntax | 5.0 | View | ||
| English | SQL Syntax | 5.1 | View | ||
| English | SQL Syntax | 6.0 | View | ||
| English | Optimization | 5.0 | View | ||
| English | Optimization | 5.1 | View | ||
| English | Optimization | 6.0 | View | ||
| English | Connectors and APIs | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL Cluster API Developer | View | TGZ | Zip | US Ltr | A4 | |
| English | Functions and Operators | 5.0 | View | ||
| English | Functions and Operators | 5.1 | View | ||
| English | Functions and Operators | 6.0 | View |
Functionality
| MySQL Version | HTML Online | HTML Page/chapter | |||
| English | Views | 5.0 | View | ||
| English | Views | 5.1 | View | ||
| English | Views | 6.0 | View | ||
| English | Stored Programs | 5.0 | View | ||
| English | Stored Programs | 5.1 | View | ||
| English | Stored Programs | 6.0 | View | ||
| English | Replication | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Replication | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Replication | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Spatial Extensions | 5.0 | View | ||
| English | Spatial Extensions | 5.1 | View | ||
| English | Spatial Extensions | 6.0 | View | ||
| English | Precision Math | 5.0 | View | ||
| English | Precision Math | 5.1 | View | ||
| English | Precision Math | 6.0 | View | ||
| English | Internationalization and Localization | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Internationalization and Localization | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Internationalization and Localization | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | Partitioning | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | Partitioning | 6.0 | View | TGZ | Zip | US Ltr | A4 |
Connectors
HA/Scalability
| MySQL Version | HTML Online | HTML Page/chapter | |||
| English | MySQL Cluster NDB 6.X | 5.1 | View | ||
| English | HA/Scalability Guide | View | TGZ | Zip | US Ltr | A4 | |
| English | MySQL & DRBD | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL & DRBD | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL & DRBD | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | memcached | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | memcached | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | memcached | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL and Virtualization | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL and Virtualization | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL and Virtualization | 6.0 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL Proxy | 5.0 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL Proxy | 5.1 | View | TGZ | Zip | US Ltr | A4 |
| English | MySQL Proxy | 6.0 | View | TGZ | Zip | US Ltr | A4 |
Trouble opening CHM documents?
If an error occurs when you try to open a CHM documents and the document content does not display, right-click on the document icon and select Properties. Then click the Unblock button in the Properties window and click Apply.
Trouble with PDF files?
Acrobat Reader 6.0 has a couple of issues and may display errors when opening or scrolling through one of our PDF files. We recommend using Adobe Reader 7.0, kpdf (Linux), or Preview (Mac OS X).
Installing the Eclipse documentation plugin
You can install the Eclipse documentation plugin by extracting the Eclipse package and dropping the directory into your Eclipse plugins directory.
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.