MySQL Enterprise

Get Your "Virtual DBA Assistant" Today!

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.

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.

Getting Started	Platforms	Administrators	Developers	Functionality	Connectors	HA/Scalability
Tutorial	Linux/Unix ^PDF	MySQL Version Reference ^PDF		Views	Connector/J ^PDF	MySQL Cluster NDB 6.X
Installation	Mac OS X ^PDF	Security ^PDF	SQL Syntax	Stored Programs	Connector/ODBC ^PDF	HA/Scalability Guide ^PDF
Upgrading	Windows ^PDF	MySQL Enterprise Monitor ^PDF	Optimization	Replication ^PDF	.NET/Mono ^PDF	MySQL & DRBD ^PDF
Server Administration	Solaris ^PDF	Startup/Shutdown ^PDF	Connectors and APIs ^PDF	Spatial Extensions	C++ ^PDF	memcached ^PDF
Storage Engines	Building from Source ^PDF	Partitioning	MySQL Cluster API Developer ^PDF	Precision Math	OpenOffice.org ^PDF	MySQL and Virtualization ^PDF
FAQs		Backup and Recovery ^PDF	Functions and Operators	Internationalization and Localization ^PDF	PHP ^PDF	MySQL Proxy ^PDF
		Information Schema ^PDF		Partitioning ^PDF	C API
					Connector/MXJ ^PDF

MySQL Reference Manual

	MySQL Version	HTML Online	HTML Page/chapter	HTML Single page	Eclipse Doc Plugin	PDF	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	PDF
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	PDF	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	PDF	CHM
English	MySQL Enterprise Monitor	2.0	View	TGZ \| Zip	TGZ \| Zip	US Ltr \| A4	CHM

Expert Guides

		HTML Online	PDF	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

	Download DB	HTML Setup Guide	PDF Setup Guide
employee data (large dataset, includes data and test/verification suite)	Launchpad	View	US Ltr \| A4
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	PDF	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

Additional Resources

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	PDF
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	PDF
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	PDF
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	PDF
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

		MySQL Version	HTML Online	HTML Page/chapter	PDF
English	Connector/J	5.0	View	TGZ \| Zip	US Ltr \| A4
English	Connector/J	5.1	View	TGZ \| Zip	US Ltr \| A4
English	Connector/J	6.0	View	TGZ \| Zip	US Ltr \| A4
English	Connector/ODBC	5.0	View	TGZ \| Zip	US Ltr \| A4
English	Connector/ODBC	5.1	View	TGZ \| Zip	US Ltr \| A4
English	Connector/ODBC	6.0	View	TGZ \| Zip	US Ltr \| A4
English	.NET/Mono	5.0	View	TGZ \| Zip	US Ltr \| A4
English	.NET/Mono	5.1	View	TGZ \| Zip	US Ltr \| A4
English	.NET/Mono	6.0	View	TGZ \| Zip	US Ltr \| A4
English	C++	5.0	View	TGZ \| Zip	US Ltr \| A4
English	C++	5.1	View	TGZ \| Zip	US Ltr \| A4
English	C++	6.0	View	TGZ \| Zip	US Ltr \| A4
English	OpenOffice.org	5.0	View	TGZ \| Zip	US Ltr \| A4
English	OpenOffice.org	5.1	View	TGZ \| Zip	US Ltr \| A4
English	OpenOffice.org	6.0	View	TGZ \| Zip	US Ltr \| A4
English	PHP	5.0	View	TGZ \| Zip	US Ltr \| A4
English	PHP	5.1	View	TGZ \| Zip	US Ltr \| A4
English	PHP	6.0	View	TGZ \| Zip	US Ltr \| A4
English	C API	5.0	View
English	C API	5.1	View
English	C API	6.0	View
English	Connector/MXJ	5.0	View	TGZ \| Zip	US Ltr \| A4
English	Connector/MXJ	5.1	View	TGZ \| Zip	US Ltr \| A4
English	Connector/MXJ	6.0	View	TGZ \| Zip	US Ltr \| A4

HA/Scalability

		MySQL Version	HTML Online	HTML Page/chapter	PDF
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?

We are currently having intermittent issues with our CHM builds. If you have downloaded a CHM from the MySQL website, please do not report a bad CHM as a bug. CHMs are rebuilt every 6 hours. Please download a later build and use that. For more information on the problems, see Problems with the CHM Refman builds.

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.

Related pages: