MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
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
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
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
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
MySQL 8.0 Reference Manual /
SQL Statement Syntax
Table of Contents [+/-]
- 13.1 Data Definition Statements [+/-]
- 13.1.1 Atomic Data Definition Statement Support
- 13.1.2 ALTER DATABASE Syntax
- 13.1.3 ALTER EVENT Syntax
- 13.1.4 ALTER FUNCTION Syntax
- 13.1.5 ALTER INSTANCE Syntax
- 13.1.6 ALTER LOGFILE GROUP Syntax
- 13.1.7 ALTER PROCEDURE Syntax
- 13.1.8 ALTER SERVER Syntax
- 13.1.9 ALTER TABLE Syntax
- 13.1.10 ALTER TABLESPACE Syntax
- 13.1.11 ALTER VIEW Syntax
- 13.1.12 CREATE DATABASE Syntax
- 13.1.13 CREATE EVENT Syntax
- 13.1.14 CREATE FUNCTION Syntax
- 13.1.15 CREATE INDEX Syntax
- 13.1.16 CREATE LOGFILE GROUP Syntax
- 13.1.17 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 13.1.18 CREATE SERVER Syntax
- 13.1.19 CREATE SPATIAL REFERENCE SYSTEM Syntax
- 13.1.20 CREATE TABLE Syntax
- 13.1.21 CREATE TABLESPACE Syntax
- 13.1.22 CREATE TRIGGER Syntax
- 13.1.23 CREATE VIEW Syntax
- 13.1.24 DROP DATABASE Syntax
- 13.1.25 DROP EVENT Syntax
- 13.1.26 DROP FUNCTION Syntax
- 13.1.27 DROP INDEX Syntax
- 13.1.28 DROP LOGFILE GROUP Syntax
- 13.1.29 DROP PROCEDURE and DROP FUNCTION Syntax
- 13.1.30 DROP SERVER Syntax
- 13.1.31 DROP SPATIAL REFERENCE SYSTEM Syntax
- 13.1.32 DROP TABLE Syntax
- 13.1.33 DROP TABLESPACE Syntax
- 13.1.34 DROP TRIGGER Syntax
- 13.1.35 DROP VIEW Syntax
- 13.1.36 RENAME TABLE Syntax
- 13.1.37 TRUNCATE TABLE Syntax
- 13.2 Data Manipulation Statements [+/-]
- 13.3 Transactional and Locking Statements [+/-]
- 13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax
- 13.3.2 Statements That Cannot Be Rolled Back
- 13.3.3 Statements That Cause an Implicit Commit
- 13.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Syntax
- 13.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Syntax
- 13.3.6 LOCK TABLES and UNLOCK TABLES Syntax
- 13.3.7 SET TRANSACTION Syntax
- 13.3.8 XA Transactions
- 13.4 Replication Statements [+/-]
- 13.5 Prepared SQL Statement Syntax [+/-]
- 13.6 Compound-Statement Syntax [+/-]
- 13.7 Database Administration Statements [+/-]
- 13.8 Utility Statements [+/-]
This chapter describes the syntax for the SQL statements supported by MySQL.
Related Documentation
Download
this Manual
Excerpts from 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
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
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
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