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.