Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.1Mb
PDF (A4) - 43.2Mb
Man Pages (TGZ) - 295.4Kb
Man Pages (Zip) - 400.6Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  SQL Statements

Chapter 15 SQL Statements

Table of Contents

15.1 Data Definition Statements
15.1.1 Atomic Data Definition Statement Support
15.1.2 ALTER DATABASE Statement
15.1.3 ALTER EVENT Statement
15.1.4 ALTER FUNCTION Statement
15.1.5 ALTER INSTANCE Statement
15.1.6 ALTER LOGFILE GROUP Statement
15.1.7 ALTER PROCEDURE Statement
15.1.8 ALTER SERVER Statement
15.1.9 ALTER TABLE Statement
15.1.10 ALTER TABLESPACE Statement
15.1.11 ALTER VIEW Statement
15.1.12 CREATE DATABASE Statement
15.1.13 CREATE EVENT Statement
15.1.14 CREATE FUNCTION Statement
15.1.15 CREATE INDEX Statement
15.1.16 CREATE LOGFILE GROUP Statement
15.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements
15.1.18 CREATE SERVER Statement
15.1.19 CREATE SPATIAL REFERENCE SYSTEM Statement
15.1.20 CREATE TABLE Statement
15.1.21 CREATE TABLESPACE Statement
15.1.22 CREATE TRIGGER Statement
15.1.23 CREATE VIEW Statement
15.1.24 DROP DATABASE Statement
15.1.25 DROP EVENT Statement
15.1.26 DROP FUNCTION Statement
15.1.27 DROP INDEX Statement
15.1.28 DROP LOGFILE GROUP Statement
15.1.29 DROP PROCEDURE and DROP FUNCTION Statements
15.1.30 DROP SERVER Statement
15.1.31 DROP SPATIAL REFERENCE SYSTEM Statement
15.1.32 DROP TABLE Statement
15.1.33 DROP TABLESPACE Statement
15.1.34 DROP TRIGGER Statement
15.1.35 DROP VIEW Statement
15.1.36 RENAME TABLE Statement
15.1.37 TRUNCATE TABLE Statement
15.2 Data Manipulation Statements
15.2.1 CALL Statement
15.2.2 DELETE Statement
15.2.3 DO Statement
15.2.4 EXCEPT Clause
15.2.5 HANDLER Statement
15.2.6 IMPORT TABLE Statement
15.2.7 INSERT Statement
15.2.8 INTERSECT Clause
15.2.9 LOAD DATA Statement
15.2.10 LOAD XML Statement
15.2.11 Parenthesized Query Expressions
15.2.12 REPLACE Statement
15.2.13 SELECT Statement
15.2.14 Set Operations with UNION, INTERSECT, and EXCEPT
15.2.15 Subqueries
15.2.16 TABLE Statement
15.2.17 UPDATE Statement
15.2.18 UNION Clause
15.2.19 VALUES Statement
15.2.20 WITH (Common Table Expressions)
15.3 Transactional and Locking Statements
15.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements
15.3.2 Statements That Cannot Be Rolled Back
15.3.3 Statements That Cause an Implicit Commit
15.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
15.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements
15.3.6 LOCK TABLES and UNLOCK TABLES Statements
15.3.7 SET TRANSACTION Statement
15.3.8 XA Transactions
15.4 Replication Statements
15.4.1 SQL Statements for Controlling Source Servers
15.4.2 SQL Statements for Controlling Replica Servers
15.4.3 SQL Statements for Controlling Group Replication
15.5 Prepared Statements
15.5.1 PREPARE Statement
15.5.2 EXECUTE Statement
15.5.3 DEALLOCATE PREPARE Statement
15.6 Compound Statement Syntax
15.6.1 BEGIN ... END Compound Statement
15.6.2 Statement Labels
15.6.3 DECLARE Statement
15.6.4 Variables in Stored Programs
15.6.5 Flow Control Statements
15.6.6 Cursors
15.6.7 Condition Handling
15.6.8 Restrictions on Condition Handling
15.7 Database Administration Statements
15.7.1 Account Management Statements
15.7.2 Resource Group Management Statements
15.7.3 Table Maintenance Statements
15.7.4 Component, Plugin, and Loadable Function Statements
15.7.5 CLONE Statement
15.7.6 SET Statements
15.7.7 SHOW Statements
15.7.8 Other Administrative Statements
15.8 Utility Statements
15.8.1 DESCRIBE Statement
15.8.2 EXPLAIN Statement
15.8.3 HELP Statement
15.8.4 USE Statement

This chapter describes the syntax for the SQL statements supported by MySQL.