Contact MySQL
|
Login
|
Register
The world's most popular open source database
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 8.0 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 Statement Syntax
Data Definition Statements
Atomic Data Definition Statement Support
ALTER DATABASE Syntax
ALTER EVENT Syntax
ALTER FUNCTION Syntax
ALTER INSTANCE Syntax
ALTER LOGFILE GROUP Syntax
ALTER PROCEDURE Syntax
ALTER SERVER Syntax
ALTER TABLE Syntax
ALTER TABLE Partition Operations
ALTER TABLE and Generated Columns
ALTER TABLE Examples
ALTER TABLESPACE Syntax
ALTER VIEW Syntax
CREATE DATABASE Syntax
CREATE EVENT Syntax
CREATE FUNCTION Syntax
CREATE INDEX Syntax
CREATE LOGFILE GROUP Syntax
CREATE PROCEDURE and CREATE FUNCTION Syntax
CREATE SERVER Syntax
CREATE SPATIAL REFERENCE SYSTEM Syntax
CREATE TABLE Syntax
CREATE TABLE Statement Retention
Files Created by CREATE TABLE
CREATE TEMPORARY TABLE Syntax
CREATE TABLE ... LIKE Syntax
CREATE TABLE ... SELECT Syntax
Using FOREIGN KEY Constraints
CHECK Constraints
Silent Column Specification Changes
CREATE TABLE and Generated Columns
Secondary Indexes and Generated Columns
Setting NDB_TABLE Options
CREATE TABLESPACE Syntax
CREATE TRIGGER Syntax
CREATE VIEW Syntax
DROP DATABASE Syntax
DROP EVENT Syntax
DROP FUNCTION Syntax
DROP INDEX Syntax
DROP LOGFILE GROUP Syntax
DROP PROCEDURE and DROP FUNCTION Syntax
DROP SERVER Syntax
DROP SPATIAL REFERENCE SYSTEM Syntax
DROP TABLE Syntax
DROP TABLESPACE Syntax
DROP TRIGGER Syntax
DROP VIEW Syntax
RENAME TABLE Syntax
TRUNCATE TABLE Syntax
Data Manipulation Statements
CALL Syntax
DELETE Syntax
DO Syntax
HANDLER Syntax
IMPORT TABLE Syntax
INSERT Syntax
INSERT ... SELECT Syntax
INSERT ... ON DUPLICATE KEY UPDATE Syntax
INSERT DELAYED Syntax
LOAD DATA Syntax
LOAD XML Syntax
REPLACE Syntax
SELECT Syntax
SELECT ... INTO Syntax
JOIN Syntax
UNION Syntax
Subquery Syntax
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
Lateral Derived Tables
Subquery Errors
Optimizing Subqueries
Rewriting Subqueries as Joins
UPDATE Syntax
WITH Syntax (Common Table Expressions)
Transactional and Locking Statements
START TRANSACTION, COMMIT, and ROLLBACK Syntax
Statements That Cannot Be Rolled Back
Statements That Cause an Implicit Commit
SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Syntax
LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Syntax
LOCK TABLES and UNLOCK TABLES Syntax
SET TRANSACTION Syntax
XA Transactions
XA Transaction SQL Syntax
XA Transaction States
Replication Statements
SQL Statements for Controlling Master Servers
PURGE BINARY LOGS Syntax
RESET MASTER Syntax
SET sql_log_bin Syntax
SQL Statements for Controlling Slave Servers
CHANGE MASTER TO Syntax
CHANGE REPLICATION FILTER Syntax
MASTER_POS_WAIT() Syntax
RESET SLAVE Syntax
SET GLOBAL sql_slave_skip_counter Syntax
START SLAVE Syntax
STOP SLAVE Syntax
SQL Statements for Controlling Group Replication
START GROUP_REPLICATION Syntax
STOP GROUP_REPLICATION Syntax
Function which Configures Group Replication Primary
Functions which Configure the Group Replication Mode
Functions to Inspect and Configure the Maximum Consensus Instances of a Group
Functions to Inspect and Set the Group Replication Communication Protocol Version
Prepared SQL Statement Syntax
PREPARE Syntax
EXECUTE Syntax
DEALLOCATE PREPARE Syntax
Compound-Statement Syntax
BEGIN ... END Compound-Statement Syntax
Statement Label Syntax
DECLARE Syntax
Variables in Stored Programs
Local Variable DECLARE Syntax
Local Variable Scope and Resolution
Flow Control Statements
CASE Syntax
IF Syntax
ITERATE Syntax
LEAVE Syntax
LOOP Syntax
REPEAT Syntax
RETURN Syntax
WHILE Syntax
Cursors
Cursor CLOSE Syntax
Cursor DECLARE Syntax
Cursor FETCH Syntax
Cursor OPEN Syntax
Condition Handling
DECLARE ... CONDITION Syntax
DECLARE ... HANDLER Syntax
GET DIAGNOSTICS Syntax
RESIGNAL Syntax
SIGNAL Syntax
Scope Rules for Handlers
The MySQL Diagnostics Area
Condition Handling and OUT or INOUT Parameters
Database Administration Statements
Account Management Statements
ALTER USER Syntax
CREATE ROLE Syntax
CREATE USER Syntax
DROP ROLE Syntax
DROP USER Syntax
GRANT Syntax
RENAME USER Syntax
REVOKE Syntax
SET DEFAULT ROLE Syntax
SET PASSWORD Syntax
SET ROLE Syntax
Resource Group Management Statements
ALTER RESOURCE GROUP Syntax
CREATE RESOURCE GROUP Syntax
DROP RESOURCE GROUP Syntax
SET RESOURCE GROUP Syntax
Table Maintenance Statements
ANALYZE TABLE Syntax
CHECK TABLE Syntax
CHECKSUM TABLE Syntax
OPTIMIZE TABLE Syntax
REPAIR TABLE Syntax
Component, Plugin, and User-Defined Function Statements
CREATE FUNCTION Syntax for User-Defined Functions
DROP FUNCTION Syntax
INSTALL COMPONENT Syntax
INSTALL PLUGIN Syntax
UNINSTALL COMPONENT Syntax
UNINSTALL PLUGIN Syntax
SET Syntax
SET Syntax for Variable Assignment
SET CHARACTER SET Syntax
SET NAMES Syntax
SHOW Syntax
SHOW BINARY LOGS Syntax
SHOW BINLOG EVENTS Syntax
SHOW CHARACTER SET Syntax
SHOW COLLATION Syntax
SHOW COLUMNS Syntax
SHOW CREATE DATABASE Syntax
SHOW CREATE EVENT Syntax
SHOW CREATE FUNCTION Syntax
SHOW CREATE PROCEDURE Syntax
SHOW CREATE TABLE Syntax
SHOW CREATE TRIGGER Syntax
SHOW CREATE USER Syntax
SHOW CREATE VIEW Syntax
SHOW DATABASES Syntax
SHOW ENGINE Syntax
SHOW ENGINES Syntax
SHOW ERRORS Syntax
SHOW EVENTS Syntax
SHOW FUNCTION CODE Syntax
SHOW FUNCTION STATUS Syntax
SHOW GRANTS Syntax
SHOW INDEX Syntax
SHOW MASTER STATUS Syntax
SHOW OPEN TABLES Syntax
SHOW PLUGINS Syntax
SHOW PRIVILEGES Syntax
SHOW PROCEDURE CODE Syntax
SHOW PROCEDURE STATUS Syntax
SHOW PROCESSLIST Syntax
SHOW PROFILE Syntax
SHOW PROFILES Syntax
SHOW RELAYLOG EVENTS Syntax
SHOW SLAVE HOSTS Syntax
SHOW SLAVE STATUS Syntax
SHOW STATUS Syntax
SHOW TABLE STATUS Syntax
SHOW TABLES Syntax
SHOW TRIGGERS Syntax
SHOW VARIABLES Syntax
SHOW WARNINGS Syntax
Other Administrative Statements
BINLOG Syntax
CACHE INDEX Syntax
FLUSH Syntax
KILL Syntax
LOAD INDEX INTO CACHE Syntax
RESET Syntax
RESET PERSIST Syntax
RESTART Syntax
SHUTDOWN Syntax
Utility Statements
DESCRIBE Syntax
EXPLAIN Syntax
HELP Syntax
USE Syntax
MySQL Data Dictionary
The InnoDB Storage Engine
Alternative Storage Engines
Replication
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
MySQL NDB Cluster 8.0
Partitioning
Stored Objects
INFORMATION_SCHEMA Tables
MySQL Performance Schema
MySQL sys Schema
Connectors and APIs
Extending MySQL
MySQL Enterprise Edition
MySQL Workbench
MySQL 8.0 Frequently Asked Questions
Errors, Error Codes, and Common Problems
Restrictions and Limits
Indexes
MySQL Glossary
Related Documentation
MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Download this Manual
PDF (US Ltr)
- 46.1Mb
PDF (A4)
- 46.1Mb
PDF (RPM)
- 41.5Mb
HTML Download (TGZ)
- 10.6Mb
HTML Download (Zip)
- 10.6Mb
HTML Download (RPM)
- 9.1Mb
Man Pages (TGZ)
- 220.4Kb
Man Pages (Zip)
- 325.8Kb
Info (Gzip)
- 4.1Mb
Info (Zip)
- 4.1Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
Security in MySQL
Starting and Stopping MySQL
MySQL and Linux/Unix
MySQL and Windows
MySQL and OS X
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Secure Deployment Guide
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
version 8.0
5.7
5.6
5.5
5.6 Japanese
MySQL 8.0 Reference Manual
/
SQL Statement Syntax
/ Data Manipulation Statements
13.2 Data Manipulation Statements
[
+/-
]
13.2.1 CALL Syntax
13.2.2 DELETE Syntax
13.2.3 DO Syntax
13.2.4 HANDLER Syntax
13.2.5 IMPORT TABLE Syntax
13.2.6 INSERT Syntax
13.2.7 LOAD DATA Syntax
13.2.8 LOAD XML Syntax
13.2.9 REPLACE Syntax
13.2.10 SELECT Syntax
13.2.11 Subquery Syntax
13.2.12 UPDATE Syntax
13.2.13 WITH Syntax (Common Table Expressions)
PREV
HOME
UP
NEXT
Related Documentation
MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Download this Manual
PDF (US Ltr)
- 46.1Mb
PDF (A4)
- 46.1Mb
PDF (RPM)
- 41.5Mb
HTML Download (TGZ)
- 10.6Mb
HTML Download (Zip)
- 10.6Mb
HTML Download (RPM)
- 9.1Mb
Man Pages (TGZ)
- 220.4Kb
Man Pages (Zip)
- 325.8Kb
Info (Gzip)
- 4.1Mb
Info (Zip)
- 4.1Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
Security in MySQL
Starting and Stopping MySQL
MySQL and Linux/Unix
MySQL and Windows
MySQL and OS X
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Secure Deployment Guide
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository