Beta Draft: 2017-03-27

MySQL 8.0 Reference Manual


This is the MySQL™ Reference Manual. It documents MySQL 8.0 through 8.0.2.

MySQL 8.0 status.  MySQL 8.0 is a development series not recommended for production use.

MySQL Cluster is currently not supported in MySQL 8.0. For information about MySQL Cluster, please see MySQL NDB Cluster 7.5.

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

For notes detailing the changes in each release, see the MySQL 8.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.

Licensing information—MySQL 8.0.  This product may include third-party software, used under license. If you are using a Community release of MySQL 8.0, see this document for licensing information, including licensing information relating to third-party software that may be included in this Community release.

Document generated on: 2017-03-27 (revision: 51407)

Table of Contents     [+/-]

Preface and Legal Notices
1 General Information     [+/-]
2 Installing and Upgrading MySQL     [+/-]
3 Using MySQL as a Document Store     [+/-]
4 Tutorial     [+/-]
5 MySQL Programs     [+/-]
6 MySQL Server Administration     [+/-]
7 Security     [+/-]
8 Backup and Recovery     [+/-]
9 Optimization     [+/-]
10 Language Structure     [+/-]
11 Globalization     [+/-]
12 Data Types     [+/-]
13 Functions and Operators     [+/-]
14 SQL Statement Syntax     [+/-]
15 MySQL Data Dictionary     [+/-]
16 The InnoDB Storage Engine     [+/-]
17 Alternative Storage Engines     [+/-]
18 High Availability and Scalability     [+/-]
19 Replication     [+/-]
20 Partitioning     [+/-]
21 Stored Programs and Views     [+/-]
22 INFORMATION_SCHEMA Tables     [+/-]
23 MySQL Performance Schema     [+/-]
24 MySQL sys Schema     [+/-]
25 Connectors and APIs     [+/-]
26 Extending MySQL     [+/-]
27 MySQL Enterprise Edition     [+/-]
28 MySQL Workbench
A MySQL 8.0 Frequently Asked Questions     [+/-]
B Errors, Error Codes, and Common Problems     [+/-]
C Restrictions and Limits     [+/-]
D Indexes     [+/-]
MySQL Glossary