Chapter 13 SQL Statements

Table of Contents

13.1 Data Definition Statements
13.1.1 ALTER DATABASE Statement
13.1.2 ALTER EVENT Statement
13.1.3 ALTER FUNCTION Statement
13.1.4 ALTER INSTANCE Statement
13.1.5 ALTER LOGFILE GROUP Statement
13.1.6 ALTER PROCEDURE Statement
13.1.7 ALTER SERVER Statement
13.1.8 ALTER TABLE Statement
13.1.9 ALTER TABLESPACE Statement
13.1.10 ALTER VIEW Statement
13.1.11 CREATE DATABASE Statement
13.1.12 CREATE EVENT Statement
13.1.13 CREATE FUNCTION Statement
13.1.14 CREATE INDEX Statement
13.1.15 CREATE LOGFILE GROUP Statement
13.1.16 CREATE PROCEDURE and CREATE FUNCTION Statements
13.1.17 CREATE SERVER Statement
13.1.18 CREATE TABLE Statement
13.1.19 CREATE TABLESPACE Statement
13.1.20 CREATE TRIGGER Statement
13.1.21 CREATE VIEW Statement
13.1.22 DROP DATABASE Statement
13.1.23 DROP EVENT Statement
13.1.24 DROP FUNCTION Statement
13.1.25 DROP INDEX Statement
13.1.26 DROP LOGFILE GROUP Statement
13.1.27 DROP PROCEDURE and DROP FUNCTION Statements
13.1.28 DROP SERVER Statement
13.1.29 DROP TABLE Statement
13.1.30 DROP TABLESPACE Statement
13.1.31 DROP TRIGGER Statement
13.1.32 DROP VIEW Statement
13.1.33 RENAME TABLE Statement
13.1.34 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 HANDLER Statement
13.2.5 INSERT Statement
13.2.6 LOAD DATA Statement
13.2.7 LOAD XML Statement
13.2.8 REPLACE Statement
13.2.9 SELECT Statement
13.2.10 Subqueries
13.2.11 UPDATE Statement
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 TABLES and UNLOCK TABLES Statements
13.3.6 SET TRANSACTION Statement
13.3.7 XA Transactions
13.4 Replication Statements
13.4.1 SQL Statements for Controlling Replication 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 Statements
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.7 Database Administration Statements
13.7.1 Account Management Statements
13.7.2 Table Maintenance Statements
13.7.3 Plugin and User-Defined Function Statements
13.7.4 SET Statements
13.7.5 SHOW Statements
13.7.6 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.