Chapter 13 SQL Statements

Table of Contents

13.1 Data Definition Statements

13.1.1 Atomic Data Definition Statement Support

13.1.2 ALTER DATABASE Statement

13.1.3 ALTER EVENT Statement

13.1.4 ALTER FUNCTION Statement

13.1.5 ALTER INSTANCE Statement

13.1.6 ALTER LOGFILE GROUP Statement

13.1.7 ALTER PROCEDURE Statement

13.1.8 ALTER SERVER Statement

13.1.9 ALTER TABLE Statement

13.1.10 ALTER TABLESPACE Statement

13.1.11 ALTER VIEW Statement

13.1.12 CREATE DATABASE Statement

13.1.13 CREATE EVENT Statement

13.1.14 CREATE FUNCTION Statement

13.1.15 CREATE INDEX Statement

13.1.16 CREATE LOGFILE GROUP Statement

13.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements

13.1.18 CREATE SERVER Statement

13.1.19 CREATE SPATIAL REFERENCE SYSTEM Statement

13.1.20 CREATE TABLE Statement

13.1.21 CREATE TABLESPACE Statement

13.1.22 CREATE TRIGGER Statement

13.1.23 CREATE VIEW Statement

13.1.24 DROP DATABASE Statement

13.1.25 DROP EVENT Statement

13.1.26 DROP FUNCTION Statement

13.1.27 DROP INDEX Statement

13.1.28 DROP LOGFILE GROUP Statement

13.1.29 DROP PROCEDURE and DROP FUNCTION Statements

13.1.30 DROP SERVER Statement

13.1.31 DROP SPATIAL REFERENCE SYSTEM Statement

13.1.32 DROP TABLE Statement

13.1.33 DROP TABLESPACE Statement

13.1.34 DROP TRIGGER Statement

13.1.35 DROP VIEW Statement

13.1.36 RENAME TABLE Statement

13.1.37 TRUNCATE TABLE Statement

13.2 Data Manipulation Statements

13.2.1 CALL Statement

13.2.2 DELETE Statement

13.2.3 DO Statement

13.2.4 EXCEPT Clause

13.2.5 HANDLER Statement

13.2.6 IMPORT TABLE Statement

13.2.7 INSERT Statement

13.2.8 INTERSECT Clause

13.2.9 LOAD DATA Statement

13.2.10 LOAD XML Statement

13.2.11 Parenthesized Query Expressions

13.2.12 REPLACE Statement

13.2.13 SELECT Statement

13.2.14 Set Operations with UNION, INTERSECT, and EXCEPT

13.2.15 Subqueries

13.2.16 TABLE Statement

13.2.17 UPDATE Statement

13.2.18 UNION Clause

13.2.19 VALUES Statement

13.2.20 WITH (Common Table Expressions)

13.3 Transactional and Locking Statements

13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements

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 Statements

13.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements

13.3.6 LOCK TABLES and UNLOCK TABLES Statements

13.3.7 SET TRANSACTION Statement

13.3.8 XA Transactions

13.4 Replication Statements

13.4.1 SQL Statements for Controlling Source Servers

13.4.2 SQL Statements for Controlling Replica Servers

13.4.3 SQL Statements for Controlling Group Replication

13.5 Prepared Statements

13.5.1 PREPARE Statement

13.5.2 EXECUTE Statement

13.5.3 DEALLOCATE PREPARE Statement

13.6 Compound Statement Syntax

13.6.1 BEGIN ... END Compound Statement

13.6.2 Statement Labels

13.6.3 DECLARE Statement

13.6.4 Variables in Stored Programs

13.6.5 Flow Control Statements

13.6.6 Cursors

13.6.7 Condition Handling

13.6.8 Restrictions on Condition Handling

13.7 Database Administration Statements

13.7.1 Account Management Statements

13.7.2 Resource Group Management Statements

13.7.3 Table Maintenance Statements

13.7.4 Component, Plugin, and Loadable Function Statements

13.7.5 CLONE Statement

13.7.6 SET Statements

13.7.7 SHOW Statements

13.7.8 Other Administrative Statements

13.8 Utility Statements

13.8.1 DESCRIBE Statement

13.8.2 EXPLAIN Statement

13.8.3 HELP Statement

13.8.4 USE Statement

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