MySQL 8.2 Release Notes
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.5 Prepared Statements
- 13.6 Compound Statement Syntax
- 13.7 Database Administration Statements
- 13.8 Utility Statements
This chapter describes the syntax for the SQL statements supported by MySQL.