MySQL 8.4 Release Notes
- 15.1 数据定义语句15.1 Data Definition Statements
- 15.1.1 原子数据定义语句支持15.1.1 Atomic Data Definition Statement Support
- 15.1.2 ALTER DATABASE 语句15.1.2 ALTER DATABASE Statement
- 15.1.3 ALTER EVENT 语句15.1.3 ALTER EVENT Statement
- 15.1.4 ALTER FUNCTION 语句15.1.4 ALTER FUNCTION Statement
- 15.1.5 ALTER INSTANCE 语句15.1.5 ALTER INSTANCE Statement
- 15.1.6 ALTER LOGFILE GROUP 语句15.1.6 ALTER LOGFILE GROUP Statement
- 15.1.7 ALTER PROCEDURE 语句15.1.7 ALTER PROCEDURE Statement
- 15.1.8 ALTER SERVER 语句15.1.8 ALTER SERVER Statement
- 15.1.9 ALTER TABLE 语句15.1.9 ALTER TABLE Statement
- 15.1.10 ALTER TABLESPACE 语句15.1.10 ALTER TABLESPACE Statement
- 15.1.11 ALTER VIEW 语句15.1.11 ALTER VIEW Statement
- 15.1.12 CREATE DATABASE 语句15.1.12 CREATE DATABASE Statement
- 15.1.13 CREATE EVENT 语句15.1.13 CREATE EVENT Statement
- 15.1.14 CREATE FUNCTION 语句15.1.14 CREATE FUNCTION Statement
- 15.1.15 CREATE INDEX 语句15.1.15 CREATE INDEX Statement
- 15.1.16 CREATE LOGFILE GROUP 语句15.1.16 CREATE LOGFILE GROUP Statement
- 15.1.17 CREATE PROCEDURE 和 CREATE FUNCTION 语句15.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements
- 15.1.18 CREATE SERVER 语句15.1.18 CREATE SERVER Statement
- 15.1.19 CREATE SPATIAL REFERENCE SYSTEM 语句15.1.19 CREATE SPATIAL REFERENCE SYSTEM Statement
- 15.1.20 CREATE TABLE 语句15.1.20 CREATE TABLE Statement
- 15.1.21 CREATE TABLESPACE 语句15.1.21 CREATE TABLESPACE Statement
- 15.1.22 CREATE TRIGGER 语句15.1.22 CREATE TRIGGER Statement
- 15.1.23 CREATE VIEW 语句15.1.23 CREATE VIEW Statement
- 15.1.24 DROP DATABASE 语句15.1.24 DROP DATABASE Statement
- 15.1.25 DROP EVENT 语句15.1.25 DROP EVENT Statement
- 15.1.26 DROP FUNCTION 语句15.1.26 DROP FUNCTION Statement
- 15.1.27 DROP INDEX 语句15.1.27 DROP INDEX Statement
- 15.1.28 DROP LOGFILE GROUP 语句15.1.28 DROP LOGFILE GROUP Statement
- 15.1.29 DROP PROCEDURE 和 DROP FUNCTION 语句15.1.29 DROP PROCEDURE and DROP FUNCTION Statements
- 15.1.30 DROP SERVER 语句15.1.30 DROP SERVER Statement
- 15.1.31 DROP SPATIAL REFERENCE SYSTEM 语句15.1.31 DROP SPATIAL REFERENCE SYSTEM Statement
- 15.1.32 DROP TABLE 语句15.1.32 DROP TABLE Statement
- 15.1.33 DROP TABLESPACE 语句15.1.33 DROP TABLESPACE Statement
- 15.1.34 DROP TRIGGER 语句15.1.34 DROP TRIGGER Statement
- 15.1.35 DROP VIEW 语句15.1.35 DROP VIEW Statement
- 15.1.36 RENAME TABLE 语句15.1.36 RENAME TABLE Statement
- 15.1.37 TRUNCATE TABLE 语句15.1.37 TRUNCATE TABLE Statement
- 15.2 数据操作语句15.2 Data Manipulation Statements
- 15.2.1 CALL 语句15.2.1 CALL Statement
- 15.2.2 DELETE 语句15.2.2 DELETE Statement
- 15.2.3 DO 语句15.2.3 DO Statement
- 15.2.4 EXCEPT 子句15.2.4 EXCEPT Clause
- 15.2.5 HANDLER 语句15.2.5 HANDLER Statement
- 15.2.6 IMPORT TABLE 语句15.2.6 IMPORT TABLE Statement
- 15.2.7 INSERT 语句15.2.7 INSERT Statement
- 15.2.8 INTERSECT 子句15.2.8 INTERSECT Clause
- 15.2.9 LOAD DATA 语句15.2.9 LOAD DATA Statement
- 15.2.10 LOAD XML 语句15.2.10 LOAD XML Statement
- 15.2.11 括号查询表达式15.2.11 Parenthesized Query Expressions
- 15.2.12 REPLACE 语句15.2.12 REPLACE Statement
- 15.2.13 SELECT 语句15.2.13 SELECT Statement
- 15.2.14 使用 UNION、INTERSECT 和 EXCEPT 的集合操作15.2.14 Set Operations with UNION, INTERSECT, and EXCEPT
- 15.2.15 子查询15.2.15 Subqueries
- 15.2.16 TABLE 语句15.2.16 TABLE Statement
- 15.2.17 UPDATE 语句15.2.17 UPDATE Statement
- 15.2.18 UNION 子句15.2.18 UNION Clause
- 15.2.19 VALUES 语句15.2.19 VALUES Statement
- 15.2.20 WITH（公共表表达式）15.2.20 WITH (Common Table Expressions)
- 15.3 事务和锁定语句15.3 Transactional and Locking Statements
- 15.3.1 START TRANSACTION、COMMIT 和 ROLLBACK 语句15.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements
- 15.3.2 无法回滚的语句15.3.2 Statements That Cannot Be Rolled Back
- 15.3.3 导致隐式提交的语句15.3.3 Statements That Cause an Implicit Commit
- 15.3.4 SAVEPOINT、ROLLBACK TO SAVEPOINT 和 RELEASE SAVEPOINT 语句15.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
- 15.3.5 LOCK INSTANCE FOR BACKUP 和 UNLOCK INSTANCE 语句15.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements
- 15.3.6 LOCK TABLES 和 UNLOCK TABLES 语句15.3.6 LOCK TABLES and UNLOCK TABLES Statements
- 15.3.7 SET TRANSACTION 语句15.3.7 SET TRANSACTION Statement
- 15.3.8 XA 事务15.3.8 XA Transactions
- 15.4 复制语句15.4 Replication Statements
- 15.5 预处理语句15.5 Prepared Statements
- 15.6 复合语句语法15.6 Compound Statement Syntax
- 15.6.1 BEGIN ... END 复合语句15.6.1 BEGIN ... END Compound Statement
- 15.6.2 语句标签15.6.2 Statement Labels
- 15.6.3 DECLARE 语句15.6.3 DECLARE Statement
- 15.6.4 存储程序中的变量15.6.4 Variables in Stored Programs
- 15.6.5 流程控制语句15.6.5 Flow Control Statements
- 15.6.6 游标15.6.6 Cursors
- 15.6.7 条件处理15.6.7 Condition Handling
- 15.6.8 条件处理的限制15.6.8 Restrictions on Condition Handling
- 15.7 数据库管理语句15.7 Database Administration Statements
- 15.7.1 账户管理语句15.7.1 Account Management Statements
- 15.7.2 资源组管理语句15.7.2 Resource Group Management Statements
- 15.7.3 表维护语句15.7.3 Table Maintenance Statements
- 15.7.4 组件、插件和可加载函数语句15.7.4 Component, Plugin, and Loadable Function Statements
- 15.7.5 CLONE 语句15.7.5 CLONE Statement
- 15.7.6 SET 语句15.7.6 SET Statements
- 15.7.7 SHOW 语句15.7.7 SHOW Statements
- 15.7.8 其他管理语句15.7.8 Other Administrative Statements
- 15.8 实用语句15.8 Utility Statements
本章描述了 MySQL 支持的SQL语句的语法。This chapter describes the syntax for the SQL statements supported by MySQL.