MySQL 8.4 Release Notes
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.5 Prepared Statements
- 15.6 Compound Statement Syntax
- 15.7 Database Administration Statements
- 15.8 Utility Statements
This chapter describes the syntax for the SQL statements supported by MySQL.