Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 5.7 Reference Manual
Preface and Legal Notices
General Information
Installing and Upgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
SQL Statements
Data Definition Statements
ALTER DATABASE Statement
ALTER EVENT Statement
ALTER FUNCTION Statement
ALTER INSTANCE Statement
ALTER LOGFILE GROUP Statement
ALTER PROCEDURE Statement
ALTER SERVER Statement
ALTER TABLE Statement
ALTER TABLE Partition Operations
ALTER TABLE and Generated Columns
ALTER TABLE Examples
ALTER TABLESPACE Statement
ALTER VIEW Statement
CREATE DATABASE Statement
CREATE EVENT Statement
CREATE FUNCTION Statement
CREATE INDEX Statement
CREATE LOGFILE GROUP Statement
CREATE PROCEDURE and CREATE FUNCTION Statements
CREATE SERVER Statement
CREATE TABLE Statement
Files Created by CREATE TABLE
CREATE TEMPORARY TABLE Statement
CREATE TABLE ... LIKE Statement
CREATE TABLE ... SELECT Statement
FOREIGN KEY Constraints
Silent Column Specification Changes
CREATE TABLE and Generated Columns
Secondary Indexes and Generated Columns
Setting NDB Comment Options
CREATE TABLESPACE Statement
CREATE TRIGGER Statement
CREATE VIEW Statement
DROP DATABASE Statement
DROP EVENT Statement
DROP FUNCTION Statement
DROP INDEX Statement
DROP LOGFILE GROUP Statement
DROP PROCEDURE and DROP FUNCTION Statements
DROP SERVER Statement
DROP TABLE Statement
DROP TABLESPACE Statement
DROP TRIGGER Statement
DROP VIEW Statement
RENAME TABLE Statement
TRUNCATE TABLE Statement
Data Manipulation Statements
CALL Statement
DELETE Statement
DO Statement
HANDLER Statement
INSERT Statement
INSERT ... SELECT Statement
INSERT ... ON DUPLICATE KEY UPDATE Statement
INSERT DELAYED Statement
LOAD DATA Statement
LOAD XML Statement
REPLACE Statement
SELECT Statement
SELECT ... INTO Statement
JOIN Clause
UNION Clause
Subqueries
The Subquery as Scalar Operand
Comparisons Using Subqueries
Subqueries with ANY, IN, or SOME
Subqueries with ALL
Row Subqueries
Subqueries with EXISTS or NOT EXISTS
Correlated Subqueries
Derived Tables
Subquery Errors
Optimizing Subqueries
Rewriting Subqueries as Joins
Restrictions on Subqueries
UPDATE Statement
Transactional and Locking Statements
START TRANSACTION, COMMIT, and ROLLBACK Statements
Statements That Cannot Be Rolled Back
Statements That Cause an Implicit Commit
SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
LOCK TABLES and UNLOCK TABLES Statements
SET TRANSACTION Statement
XA Transactions
XA Transaction SQL Statements
XA Transaction States
Restrictions on XA Transactions
Replication Statements
SQL Statements for Controlling Replication Source Servers
PURGE BINARY LOGS Statement
RESET MASTER Statement
SET sql_log_bin Statement
SQL Statements for Controlling Replica Servers
CHANGE MASTER TO Statement
CHANGE REPLICATION FILTER Statement
RESET SLAVE Statement
SET GLOBAL sql_slave_skip_counter Syntax
START SLAVE Statement
STOP SLAVE Statement
SQL Statements for Controlling Group Replication
START GROUP_REPLICATION Statement
STOP GROUP_REPLICATION Statement
Prepared Statements
PREPARE Statement
EXECUTE Statement
DEALLOCATE PREPARE Statement
Compound Statements
BEGIN ... END Compound Statement
Statement Labels
DECLARE Statement
Variables in Stored Programs
Local Variable DECLARE Statement
Local Variable Scope and Resolution
Flow Control Statements
CASE Statement
IF Statement
ITERATE Statement
LEAVE Statement
LOOP Statement
REPEAT Statement
RETURN Statement
WHILE Statement
Cursors
Cursor CLOSE Statement
Cursor DECLARE Statement
Cursor FETCH Statement
Cursor OPEN Statement
Restrictions on Server-Side Cursors
Condition Handling
DECLARE ... CONDITION Statement
DECLARE ... HANDLER Statement
GET DIAGNOSTICS Statement
RESIGNAL Statement
SIGNAL Statement
Scope Rules for Handlers
The MySQL Diagnostics Area
Condition Handling and OUT or INOUT Parameters
Restrictions on Condition Handling
Database Administration Statements
Account Management Statements
ALTER USER Statement
CREATE USER Statement
DROP USER Statement
GRANT Statement
RENAME USER Statement
REVOKE Statement
SET PASSWORD Statement
Table Maintenance Statements
ANALYZE TABLE Statement
CHECK TABLE Statement
CHECKSUM TABLE Statement
OPTIMIZE TABLE Statement
REPAIR TABLE Statement
Plugin and Loadable Function Statements
CREATE FUNCTION Statement for Loadable Functions
DROP FUNCTION Statement for Loadable Functions
INSTALL PLUGIN Statement
UNINSTALL PLUGIN Statement
SET Statem