Documentation Home
MySQL 8.3 Reference Manual
Related Documentation
MySQL 8.3 Release Notes
Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 294.0Kb
Man Pages (Zip) - 409.0Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 8.3
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows


MySQL 8.3 Reference Manual  /  Indexes  /  Operator Index

Operator Index

Symbols | A | B | C | D | E | I | L | M | N | O | R | V | X

Symbols

[]

-

Section 14.6.1, “算术运算符”
Section 14.10, “Cast 函数和运算符”
Section 11.5, “表达式”
Section 13.1.1, “数值数据类型语法”
Section 26.6, “Restrictions and Limitations on 分区”

!

Section 11.5, “表达式”
Section 14.4.3, “Logical 运算符”
Section 14.4.1, “运算符优先级”

!=

Section 14.4.2, “比较函数和运算符”
Section 14.4.1, “运算符优先级”
Section 10.2.1.2, “Range 优化”
Section 13.5, “JSON 数据类型”

%

Section 14.6.1, “算术运算符”

&

Section 14.12, “Bit 函数和运算符”
Section 15.1.20, “CREATE TABLE 语句”
Section 26.6, “Restrictions and Limitations on 分区”

&&

Section 14.4.3, “Logical 运算符”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”

>

Section 14.4.2, “比较函数和运算符”
Section 10.3.9, “Comparison of B-Tree and Hash 索引”
Section 10.8.2, “EXPLAIN 输出格式”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 10.3.11, “Optimizer Use of Generated Column 索引”
Section 10.2.1.2, “Range 优化”
Section 13.5, “JSON 数据类型”

->

Section 14.17.3, “搜索 JSON 值的函数”
Section 15.1.20.9, “二级索引和生成的列”
Section 13.5, “JSON 数据类型”

>>

Section 14.12, “Bit 函数和运算符”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 26.6, “Restrictions and Limitations on 分区”

->>

Section 15.1.15, “创建索引语句”
Section 15.1.20.9, “二级索引和生成的列”
Section 13.5, “JSON 数据类型”

>=

Section 14.4.2, “比较函数和运算符”
Section 10.3.9, “Comparison of B-Tree and Hash 索引”
Section 10.8.2, “EXPLAIN 输出格式”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 10.3.11, “Optimizer Use of Generated Column 索引”
Section 10.2.1.2, “Range 优化”
Section 13.5, “JSON 数据类型”

<

Section 14.4.2, “比较函数和运算符”
Section 10.3.9, “Comparison of B-Tree and Hash 索引”
Section 10.8.2, “EXPLAIN 输出格式”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 10.3.11, “Optimizer Use of Generated Column 索引”
Section 10.2.1.2, “Range 优化”
Section 13.5, “JSON 数据类型”
Section 5.3.4.6, “使用 NULL 值”

<>

Section 14.4.2, “比较函数和运算符”
Section 10.8.2, “EXPLAIN 输出格式”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 10.2.1.2, “Range 优化”
Section 13.5, “JSON 数据类型”
Section 5.3.4.6, “使用 NULL 值”

<<

Section 14.12, “Bit 函数和运算符”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 26.6, “Restrictions and Limitations on 分区”

<=

Section 14.4.2, “比较函数和运算符”
Section 10.3.9, “Comparison of B-Tree and Hash 索引”
Section 10.8.2, “EXPLAIN 输出格式”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 10.3.11, “Optimizer Use of Generated Column 索引”
Section 10.2.1.2, “Range 优化”
Section 13.5, “JSON 数据类型”

<=>

Section 14.4.2, “比较函数和运算符”
Section 10.8.2, “EXPLAIN 输出格式”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 10.2.1.2, “Range 优化”
Section 13.5, “JSON 数据类型”
Section 14.3, “表达式求值中的类型转换”

*

Section 14.6.1, “算术运算符”
Section 13.1.1, “数值数据类型语法”
Section 26.6, “Restrictions and Limitations on 分区”

+

Section 14.6.1, “算术运算符”
Section 14.10, “Cast 函数和运算符”
Section 11.5, “表达式”
Section 13.1.1, “数值数据类型语法”
Section 26.6, “Restrictions and Limitations on 分区”

/

Section 14.6.1, “算术运算符”
Section 26.6, “Restrictions and Limitations on 分区”
Section 7.1.8, “服务器系统变量”

:=

Section 14.4.4, “赋值运算符”
Section 14.4.1, “运算符优先级”
Section 15.7.6.1, “变量赋值的 SET 语法”
Section 11.4, “用户定义的变量”

=

Section 14.4.4, “赋值运算符”
Section 14.4.2, “比较函数和运算符”
Section 10.3.9, “Comparison of B-Tree and Hash 索引”
Section 15.2.15.7, “相关子查询”
Section 10.8.2, “EXPLAIN 输出格式”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 10.3.11, “Optimizer Use of Generated Column 索引”
Section 10.2.1.2, “Range 优化”
Section 15.2.15.12, “子查询的限制”
Section 15.7.6.1, “变量赋值的 SET 语法”
Section 14.8.1, “String 比较函数和运算符”
Section 13.5, “JSON 数据类型”
Section 11.4, “用户定义的变量”
Section 5.3.4.6, “使用 NULL 值”

^

Section 14.12, “Bit 函数和运算符”
Section 11.5, “表达式”
Section 14.4.1, “运算符优先级”
Section 26.6, “Restrictions and Limitations on 分区”

|

Section 14.12, “Bit 函数和运算符”
Section 26.6, “Restrictions and Limitations on 分区”

||

Section 14.8.3, “函数结果的字符集和排序规则”
Section 12.8.2, “COLLATE 子句优先级”
Section 11.5, “表达式”
Section 14.4.3, “Logical 运算符”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 7.1.11, “服务器 SQL 模式”

~

Section 14.12, “Bit 函数和运算符”
Section 26.6, “Restrictions and Limitations on 分区”

≪=>

Section 15.2.15.7, “相关子查询”

A

[]

AND

Section 10.3.9, “Comparison of B-Tree and Hash 索引”
Section 15.1.20, “CREATE TABLE 语句”
Section 10.2.1.3, “Index Merge 优化”
Section 14.4.3, “Logical 运算符”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 10.2.2.3, “优化子查询 with the EXISTS Strategy”
Section 10.2.1.2, “Range 优化”
Section 15.2.15.12, “子查询的限制”
Section 10.2.1.22, “Row Constructor Expression 优化”
Section 5.6.7, “搜索两个键”
Section 22.3.4.2, “选择表”
Section 22.4.4.2, “选择表”
Section 5.3.4.2, “选择特定行”
Section 14.8.1, “String 比较函数和运算符”
Section 27.5.2, “视图处理算法”

B

[]

BETWEEN

Section 14.4.2, “比较函数和运算符”
Section 10.3.9, “Comparison of B-Tree and Hash 索引”
Section 10.2.1.13, “条件过滤”
Section 10.8.2, “EXPLAIN 输出格式”
Section 10.3.11, “Optimizer Use of Generated Column 索引”
Section 15.5.1, “准备语句”
Section 10.2.1.2, “Range 优化”
Section 13.5, “JSON 数据类型”
Section 14.3, “表达式求值中的类型转换”

BINARY

Section 14.12, “Bit 函数和运算符”
Section 14.10, “Cast 函数和运算符”
Section 10.4.2.2, “优化字符和字符串类型”
Section 5.3.4.7, “模式匹配”
Section 5.3.4.4, “排序行”

C

[]

CASE

Section 15.6.5.1, “CASE 语句”
Section 11.5, “表达式”
Section 14.5, “流程控制函数”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 15.5.1, “准备语句”

CASE value WHEN compare_value THEN result END

Section 14.5, “流程控制函数”

CASE WHEN condition THEN result END

Section 14.5, “流程控制函数”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 14.5, “流程控制函数”

column->>path

Section 14.17.3, “搜索 JSON 值的函数”

column->path

Section 14.17.3, “搜索 JSON 值的函数”
Section 13.5, “JSON 数据类型”

D

[]

DIV

Section 14.6.1, “算术运算符”
Section 26.6, “Restrictions and Limitations on 分区”

E

[]

expr BETWEEN min AND max

Section 14.4.2, “比较函数和运算符”

expr IN ()

Section 14.4.2, “比较函数和运算符”

expr LIKE pat

Section 14.8.1, “String 比较函数和运算符”

expr NOT BETWEEN min AND max

Section 14.4.2, “比较函数和运算符”

expr NOT IN ()

Section 14.4.2, “比较函数和运算符”

expr NOT LIKE pat

Section 14.8.1, “String 比较函数和运算符”

expr NOT REGEXP pat

Section 14.8.2, “正则表达式”

expr NOT RLIKE pat

Section 14.8.2, “正则表达式”

expr REGEXP pat

Section 14.8.2, “正则表达式”

expr RLIKE pat

Section 14.8.2, “正则表达式”

expr1 SOUNDS LIKE expr2

Section 14.8, “String 函数和运算符”

I

[]

IN()

Section 10.8.2, “EXPLAIN 输出格式”
Section 14.4.1, “运算符优先级”
Section 10.3.11, “Optimizer Use of Generated Column 索引”
Section 10.2.1.2, “Range 优化”
Section 10.2.1.22, “Row Constructor Expression 优化”
Section 13.5, “JSON 数据类型”
Section 14.3, “表达式求值中的类型转换”
Section 25.2.4, “What is New in MySQL NDB Cluster 8.3”

IS

Section 14.4.1, “运算符优先级”

IS boolean_value

Section 14.4.2, “比较函数和运算符”

IS NOT boolean_value

Section 14.4.2, “比较函数和运算符”

IS NOT NULL

Section 14.4.2, “比较函数和运算符”
Section B.3.4.3, “NULL 值问题”
Section 10.2.1.2, “Range 优化”
Section 5.3.4.6, “使用 NULL 值”

IS NULL

Section 14.4.2, “比较函数和运算符”
Section 10.8.2, “EXPLAIN 输出格式”
Section 10.2.1.15, “IS NULL 优化”
Section 10.2.2.3, “优化子查询 with the EXISTS Strategy”
Section B.3.4.3, “NULL 值问题”
Section 10.2.1.2, “Range 优化”
Section 7.1.8, “服务器系统变量”
Section 5.3.4.6, “使用 NULL 值”

L

[]

LIKE

Section 8.2.7, “访问控制，第二阶段：请求验证”
Section 14.10, “Cast 函数和运算符”
Section 12.2, “MySQL 中的字符集和排序规则”
Section 10.3.9, “Comparison of B-Tree and Hash 索引”
Section 10.8.2, “EXPLAIN 输出格式”
Section 28.8, “Extensions to 显示语句”
Section 14.17.3, “搜索 JSON 值的函数”
Section 15.8.3, “帮助语句”
Section A.11, “MySQL 8.3 常见问题解答：MySQL 中日韩字符集”
Section 6.5.1.4, “从文本文件执行 SQL 语句”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 25.7.4, “NDB Cluster 复制 Schema and Tables”
Section 14.4.1, “运算符优先级”
Section 5.3.4.7, “模式匹配”
Section 29.4.4, “按检测信号预过滤”
Section 25.6.20, “Quick Reference: NDB Cluster SQL 语句”
Section 10.2.1.2, “Range 优化”
Section 19.1.6.3, “副本服务器选项和变量”
Section 19.2.5.4, “复制 Channel Based Filters”
Section 7.1.11, “服务器 SQL 模式”
Section 15.7.7.4, “显示字符集语句”
Section 15.7.7.5, “显示排序规则语句”
Section 15.7.7.6, “显示列语句”
Section 15.7.7.15, “显示数据库语句”
Section 15.7.7.19, “显示事件语句”
Section 15.7.7.25, “显示打开的表语句”
Section 15.7.7.30, “显示存储过程状态语句”
Section 15.7.7.39, “显示状态语句”
Section 15.7.7.40, “显示表状态语句”
Section 15.7.7.41, “显示表语句”
Section 15.7.7.42, “显示触发器语句”
Section 15.7.7.43, “显示变量语句”
Section 8.2.4, “指定账户名称”
Section 14.8.1, “String 比较函数和运算符”
Section 11.1.1, “字符串字面量”
Section 7.1.9.5, “结构化系统变量”
Section 12.8.5, “二进制排序规则与 _bin 排序规则的比较”
Section 30.4.4.5, “The ps_setup_disable_consumer() Procedure”
Section 30.4.4.6, “The ps_setup_disable_instrument() Procedure”
Section 30.4.4.9, “The ps_setup_enable_consumer() Procedure”
Section 30.4.4.10, “The ps_setup_enable_instrument() Procedure”
Section 13.3.6, “SET 类型”
Section 7.1.9, “使用系统变量”

LIKE '_A%'

Section A.11, “MySQL 8.3 常见问题解答：MySQL 中日韩字符集”

LIKE 'pattern'

Section 10.2.1.2, “Range 优化”
Section 15.7.7, “显示语句”

M

[]

MEMBER OF()

Section 15.1.15, “创建索引语句”
Section 14.17.3, “搜索 JSON 值的函数”

N

[]

N % M

Section 14.6.1, “算术运算符”
Section 14.6.2, “数学函数”

N MOD M

Section 14.6.1, “算术运算符”
Section 14.6.2, “数学函数”

NOT

Section 14.4.3, “Logical 运算符”
Section 7.1.11, “服务器 SQL 模式”

NOT IN()

Section 10.2.1.2, “Range 优化”

NOT LIKE

Section 5.3.4.7, “模式匹配”
Section 14.8.1, “String 比较函数和运算符”

NOT REGEXP

Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.8.1, “String 比较函数和运算符”

NOT RLIKE

Section 14.8.1, “String 比较函数和运算符”

O

[]

OR

Section 11.5, “表达式”
Section 15.7.1.6, “授权语句”
Section 10.2.1.3, “Index Merge 优化”
Section 14.4.3, “Logical 运算符”
Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 10.2.2.3, “优化子查询 with the EXISTS Strategy”
Section 10.2.1.2, “Range 优化”
Section 10.2.1.22, “Row Constructor Expression 优化”
Section 5.6.7, “搜索两个键”
Section 22.3.4.2, “选择表”
Section 22.4.4.2, “选择表”
Section 5.3.4.2, “选择特定行”
Section 7.1.11, “服务器 SQL 模式”
Section 14.8.1, “String 比较函数和运算符”

R

[]

REGEXP

Section 1.6.1, “MySQL 对标准 SQL 的扩展”
Section 14.4.1, “运算符优先级”
Section 5.3.4.7, “模式匹配”
Section 14.8.2, “正则表达式”
Section 12.11, “字符集的限制”

RLIKE

Section 5.3.4.7, “模式匹配”
Section 14.8.2, “正则表达式”
Section 12.11, “字符集的限制”

V

[]

value MEMBER OF()

Section 14.17.3, “搜索 JSON 值的函数”

X

[]

XOR

Section 14.19.1, “聚合函数说明”
Section 14.4.3, “Logical 运算符”

PREV   HOME   UP   NEXT
Related Documentation
MySQL 8.3 Release Notes
Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 294.0Kb
Man Pages (Zip) - 409.0Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 8.3
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows