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: Reference Manual | GUI Tools | Expert Guides | Examples | Meta Documentation | Community Contributed Documentation | Printed Books | Additional Resources
MySQL Reference Manual
Excerpts from the Reference Manual
| HTML Online | HTML Page/chapter | CHM | ||
| MySQL Server Version Reference | View | TGZ | Zip | US Ltr | A4 | CHM |
| Connectors and APIs | TGZ | Zip | US Ltr | A4 | CHM | |
| Connector/ODBC | TGZ | Zip | US Ltr | A4 | CHM | |
| Connector/J | TGZ | Zip | US Ltr | A4 | CHM | |
| Connector/NET | TGZ | Zip | US Ltr | A4 | CHM | |
| Connector/MXJ | TGZ | Zip | US Ltr | A4 | CHM |
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 | ||
Expert Guides
| HTML Online | HTML Page/chapter | CHM | ||
| MySQL Internals | View | |||
| MySQL Test Framework | View | US Ltr | A4 | CHM | |
| MySQL Cluster NDB API Guide | View | TGZ | Zip | US Ltr | A4 |
MySQL Help Tables
| Download | |
| MySQL v4.1 | Gzip | Zip |
| MySQL v5.0 | Gzip | Zip |
| MySQL v5.1 | Gzip | Zip |
To use: Download, uncompress, then load into MySQL with this command: mysql mysql < file_name
Example Databases
| Download DB | HTML Setup Guide | PDF Setup Guide | |
| world database (all versions, used in MySQL certifications and training) | Gzip | Zip | View | US Ltr | A4 |
| sakila database (requires MySQL 5.0 or later) | TGZ | Zip | View | US Ltr | A4 |
| menagerie database (all versions) | TGZ | Zip |
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
- MySQL section at FAQTs.com
- HOWTO provide Microsoft Access-like functionality on Linux with open-source tools - OpenOffice.org 1.0, unixODBC, and MySQL
- MySQL++ Manual
Printed Books
- MySQL 5.1 Cluster Certification Study Guide (December 2007)
- 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
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.
