MySQL 5.7 Reference Manual

MySQL 5.7 Reference Manual  

http://dev.mysql.com/doc/

 

 

 

Preface and Legal Notices »

Section Navigation      [Toggle]

• MySQL 5.7 Reference Manual
  • 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 The InnoDB Storage Engine
  • 15 Alternative Storage Engines
  • 16 High Availability and Scalability
  • 17 Replication
  • 18 Partitioning
  • 19 Stored Programs and Views
  • 20 INFORMATION_SCHEMA Tables
  • 21 MySQL Performance Schema
  • 22 Connectors and APIs
  • 23 Extending MySQL
  • 24 MySQL Enterprise Edition
  • 25 MySQL Workbench
  • A MySQL 5.7 Frequently Asked Questions
  • B Errors, Error Codes, and Common Problems
  • C MySQL Release Notes
  • D Restrictions and Limits
  • MySQL Glossary
  • E Licenses for Third-Party Components
  • General Index
  • C Function Index
  • Command Index
  • Function Index
  • INFORMATION_SCHEMA 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

MySQL 5.7 Reference Manual

Abstract

This is the MySQL™ Reference Manual. It documents MySQL 5.7 through 5.7.6.

MySQL Cluster is currently not supported in MySQL 5.7. For information about MySQL Cluster, please see MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4.

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

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

For legal information, see the Legal Notices.

Document generated on: 2015-01-09 (revision: 41211)

 

General	Administrators	MySQL Enterprise	Developers & Functionality	Connectors & APIs	HA/Scalability
Tutorial	Installation & Upgrades	MySQL Enterprise Edition	» MySQL Workbench	Connectors and APIs	» HA/Scalability Guide
Server Administration	MySQL Yum Repository	MySQL Enterprise Monitor	Globalization	Connector/J	MySQL and DRBD
SQL Syntax	» MySQL Installer	MySQL Enterprise Backup	Optimization	Connector/ODBC	memcached
Storage Engines	» Security	MySQL Enterprise Security	Functions and Operators	Connector/Net	MySQL and Virtualization
Server Option / Variable Reference	» Startup / Shutdown	MySQL Enterprise Audit	Views and Stored Programs	Connector/Python	MySQL Proxy
» Release Notes	» Backup and Recovery Overview	MySQL Thread Pool	Partitioning	PHP	Replication
» MySQL Version Reference	» MySQL Utilities	» Oracle Enterprise Manager for MySQL Database	Precision Math	C API	Semisynchronous Replication
FAQs	» Linux/Unix Platform Guide		Information Schema	Connector/C
	» Windows Platform Guide		Performance Schema	Connector/C++
	» OS X Platform Guide		Spatial Extensions	» MySQL for Excel
	» Solaris Platform Guide		Restrictions and Limitations
	» Building from Source

---

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 The InnoDB Storage Engine     [+/-]

15 Alternative Storage Engines     [+/-]

16 High Availability and Scalability     [+/-]

17 Replication     [+/-]

18 Partitioning     [+/-]

19 Stored Programs and Views     [+/-]

20 INFORMATION_SCHEMA Tables     [+/-]

21 MySQL Performance Schema     [+/-]

22 Connectors and APIs     [+/-]

23 Extending MySQL     [+/-]

24 MySQL Enterprise Edition     [+/-]

25 MySQL Workbench

A MySQL 5.7 Frequently Asked Questions     [+/-]

B Errors, Error Codes, and Common Problems     [+/-]

C MySQL Release Notes

D Restrictions and Limits     [+/-]

MySQL Glossary

E Licenses for Third-Party Components     [+/-]

General Index

C Function Index

Command Index

Function Index

INFORMATION_SCHEMA 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