GET_LOCK / RELEASE_LOCK 咨询锁函数partial · major · my.func.advisory_locks
ALTER TABLE ALGORITHM= / LOCK= 在线 DDL 子句none · minor · my.ddl.alter_algorithm
表/列级 CHARSET 与 COLLATE 子句partial · major · my.ddl.charset_collation
DECLARE ... HANDLER 条件处理器partial · major · my.proc.handler
DEFINER 定义者权限子句partial · minor · my.proc.definer
ENGINE= 存储引擎子句partial · minor · my.ddl.engine_clause
ENUM 枚举类型partial · major · my.type.enum
事件调度器(CREATE EVENT / ON SCHEDULE)partial · major · my.proc.event
全文索引(FULLTEXT / MATCH AGAINST)partial · major · my.ddl.fulltext
生成列(GENERATED ALWAYS AS ... VIRTUAL/STORED)partial · major · my.ddl.generated_column
USE / FORCE / IGNORE INDEX 索引提示partial · minor · my.syntax.index_hints
JSON 列 -> / ->> 操作符partial · minor · my.syntax.json_arrow
JSON_* 函数族partial · major · my.func.json_family
LOAD DATA [LOCAL] INFILE 批量装载partial · major · my.syntax.load_data
LOCK TABLES / UNLOCK TABLESpartial · major · my.syntax.lock_tables
/*+ ... */ 优化器提示(MySQL 8.0 风格)partial · minor · my.syntax.optimizer_hint
ON UPDATE CURRENT_TIMESTAMP 自动更新时间戳partial · major · my.ddl.on_update_timestamp
PARTITION BY HASH / KEY / LIST 分区partial · minor · my.ddl.partition_hash_list_key
SELECT ... INTO OUTFILE / DUMPFILEpartial · major · my.syntax.into_outfile
SET GLOBAL/SESSION 变量与 sql_modepartial · major · my.syntax.set_variables
SET 集合类型partial · major · my.type.set
SHOW 元数据语句partial · minor · my.syntax.show_statements
SIGNAL / RESIGNAL 抛出条件partial · major · my.proc.signal
空间类型与空间索引(GEOMETRY / SPATIAL INDEX)partial · major · my.ddl.spatial
SQL_CALC_FOUND_ROWS / FOUND_ROWS 分页计数partial · major · my.func.found_rows
存储函数(CREATE FUNCTION)partial · major · my.proc.stored_function
存储过程(CREATE PROCEDURE)partial · major · my.proc.stored_procedure
STRAIGHT_JOIN 连接顺序固定partial · minor · my.syntax.straight_join
系统变量 @@var 读取partial · minor · my.syntax.system_variables
触发器(CREATE TRIGGER)partial · major · my.proc.trigger