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 LOGFILE GROUP Statement

13.1.5 ALTER PROCEDURE Statement

13.1.6 ALTER SERVER Statement

13.1.7 ALTER TABLE Statement

13.1.8 ALTER TABLESPACE Statement

13.1.9 ALTER VIEW Statement

13.1.10 CREATE DATABASE Statement

13.1.11 CREATE EVENT Statement

13.1.12 CREATE FUNCTION Statement

13.1.13 CREATE INDEX Statement

13.1.14 CREATE LOGFILE GROUP Statement

13.1.15 CREATE PROCEDURE and CREATE FUNCTION Statements

13.1.16 CREATE SERVER Statement

13.1.17 CREATE TABLE Statement

13.1.18 CREATE TABLESPACE Statement

13.1.19 CREATE TRIGGER Statement

13.1.20 CREATE VIEW Statement

13.1.21 DROP DATABASE Statement

13.1.22 DROP EVENT Statement

13.1.23 DROP FUNCTION Statement

13.1.24 DROP INDEX Statement

13.1.25 DROP LOGFILE GROUP Statement

13.1.26 DROP PROCEDURE and DROP FUNCTION Statements

13.1.27 DROP SERVER Statement

13.1.28 DROP TABLE Statement

13.1.29 DROP TABLESPACE Statement

13.1.30 DROP TRIGGER Statement

13.1.31 DROP VIEW Statement

13.1.32 RENAME TABLE Statement

13.1.33 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 Master Servers

13.4.2 SQL Statements for Controlling Slave Servers

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.