MySQL 9.1 Release Notes
Symbols | A | B | C | D | E | I | L | M | N | O | R | V | X
-
!
!=
&
>
- Section 14.4.2, “Comparison Functions and Operators”
- Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 14.4.1, “Operator Precedence”
- Section 10.3.11, “Optimizer Use of Generated Column Indexes”
- Section 10.2.1.2, “Range Optimization”
- Section 13.5, “The JSON Data Type”
->
>>
->>
>=
- Section 14.4.2, “Comparison Functions and Operators”
- Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 14.4.1, “Operator Precedence”
- Section 10.3.11, “Optimizer Use of Generated Column Indexes”
- Section 10.2.1.2, “Range Optimization”
- Section 13.5, “The JSON Data Type”
<
- Section 14.4.2, “Comparison Functions and Operators”
- Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 14.4.1, “Operator Precedence”
- Section 10.3.11, “Optimizer Use of Generated Column Indexes”
- Section 10.2.1.2, “Range Optimization”
- Section 13.5, “The JSON Data Type”
- Section 5.3.4.6, “Working with NULL Values”
<>
<<
<=
- Section 14.4.2, “Comparison Functions and Operators”
- Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 14.4.1, “Operator Precedence”
- Section 10.3.11, “Optimizer Use of Generated Column Indexes”
- Section 10.2.1.2, “Range Optimization”
- Section 13.5, “The JSON Data Type”
<=>
- Section 14.4.2, “Comparison Functions and Operators”
- Section 15.2.15.7, “Correlated Subqueries”
- Section 10.15.12, “Example”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 14.4.1, “Operator Precedence”
- Section 10.2.1.2, “Range Optimization”
- Section 13.5, “The JSON Data Type”
- Section 14.3, “Type Conversion in Expression Evaluation”
*
+
/
:=
=
- Section 14.4.4, “Assignment Operators”
- Section 14.4.2, “Comparison Functions and Operators”
- Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 15.2.15.7, “Correlated Subqueries”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 14.4.1, “Operator Precedence”
- Section 10.3.11, “Optimizer Use of Generated Column Indexes”
- Section 10.2.1.2, “Range Optimization”
- Section 15.2.15.12, “Restrictions on Subqueries”
- Section 15.7.6.1, “SET Syntax for Variable Assignment”
- Section 14.8.1, “String Comparison Functions and Operators”
- Section 13.5, “The JSON Data Type”
- Section 11.4, “User-Defined Variables”
- Section 5.3.4.6, “Working with NULL Values”
^
|
||
~
AND
- Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 15.1.20, “CREATE TABLE Statement”
- Section 10.2.1.3, “Index Merge Optimization”
- Section 14.4.3, “Logical Operators”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
- Section 10.2.1.2, “Range Optimization”
- Section 15.2.15.12, “Restrictions on Subqueries”
- Section 10.2.1.22, “Row Constructor Expression Optimization”
- Section 5.6.7, “Searching on Two Keys”
- Section 22.3.4.2, “Select Tables”
- Section 22.4.4.2, “Select Tables”
- Section 5.3.4.2, “Selecting Particular Rows”
- Section 14.8.1, “String Comparison Functions and Operators”
- Section 27.6.2, “View Processing Algorithms”
BETWEEN
- Section 14.4.2, “Comparison Functions and Operators”
- Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 10.2.1.13, “Condition Filtering”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 10.3.11, “Optimizer Use of Generated Column Indexes”
- Section 15.5.1, “PREPARE Statement”
- Section 10.2.1.2, “Range Optimization”
- Section 13.5, “The JSON Data Type”
- Section 14.3, “Type Conversion in Expression Evaluation”
BINARY
CASE
CASE value WHEN compare_value THEN result END
CASE WHEN condition THEN result END
CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END
column->>path
DIV
expr BETWEEN min AND max
expr NOT BETWEEN min AND max
expr NOT IN ()
expr NOT LIKE pat
expr NOT REGEXP pat
expr NOT RLIKE pat
expr REGEXP pat
expr RLIKE pat
expr1 SOUNDS LIKE expr2
IN()
- Section 10.8.2, “EXPLAIN Output Format”
- Section 14.4.1, “Operator Precedence”
- Section 10.3.11, “Optimizer Use of Generated Column Indexes”
- Section 10.2.1.2, “Range Optimization”
- Section 10.2.1.22, “Row Constructor Expression Optimization”
- Section 13.5, “The JSON Data Type”
- Section 14.3, “Type Conversion in Expression Evaluation”
IS boolean_value
IS NOT boolean_value
IS NOT NULL
IS NULL
- Section 14.4.2, “Comparison Functions and Operators”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 10.2.1.15, “IS NULL Optimization”
- Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
- Section B.3.4.3, “Problems with NULL Values”
- Section 10.2.1.2, “Range Optimization”
- Section 7.1.8, “Server System Variables”
- Section 5.3.4.6, “Working with NULL Values”
LIKE
- Section 8.2.7, “Access Control, Stage 2: Request Verification”
- Section 14.10, “Cast Functions and Operators”
- Section 12.2, “Character Sets and Collations in MySQL”
- Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 28.8, “Extensions to SHOW Statements”
- Section 14.17.3, “Functions That Search JSON Values”
- Section 15.8.3, “HELP Statement”
- Section A.11, “MySQL 9.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 6.5.1.4, “mysql Client Server-Side Help”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 25.7.4, “NDB Cluster Replication Schema and Tables”
- Section 14.4.1, “Operator Precedence”
- Section 5.3.4.7, “Pattern Matching”
- Section 29.4.4, “Pre-Filtering by Instrument”
- Section 25.6.20, “Quick Reference: NDB Cluster SQL Statements”
- Section 10.2.1.2, “Range Optimization”
- Section 19.1.6.3, “Replica Server Options and Variables”
- Section 19.2.5.4, “Replication Channel Based Filters”
- Section 7.1.11, “Server SQL Modes”
- Section 15.7.7.4, “SHOW CHARACTER SET Statement”
- Section 15.7.7.5, “SHOW COLLATION Statement”
- Section 15.7.7.6, “SHOW COLUMNS Statement”
- Section 15.7.7.15, “SHOW DATABASES Statement”
- Section 15.7.7.19, “SHOW EVENTS Statement”
- Section 15.7.7.24, “SHOW OPEN TABLES Statement”
- Section 15.7.7.29, “SHOW PROCEDURE STATUS Statement”
- Section 15.7.7.36, “SHOW STATUS Statement”
- Section 15.7.7.37, “SHOW TABLE STATUS Statement”
- Section 15.7.7.38, “SHOW TABLES Statement”
- Section 15.7.7.39, “SHOW TRIGGERS Statement”
- Section 15.7.7.40, “SHOW VARIABLES Statement”
- Section 8.2.4, “Specifying Account Names”
- Section 14.8.1, “String Comparison Functions and Operators”
- Section 11.1.1, “String Literals”
- Section 7.1.9.5, “Structured System Variables”
- Section 12.8.5, “The binary Collation Compared to _bin Collations”
- 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.7, “The SET Type”
- Section 7.1.9, “Using System Variables”
MEMBER OF()
NOT EXISTS()
NOT LIKE
NOT REGEXP
OR
- Section 11.5, “Expressions”
- Section 15.7.1.6, “GRANT Statement”
- Section 10.2.1.3, “Index Merge Optimization”
- Section 14.4.3, “Logical Operators”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 14.4.1, “Operator Precedence”
- Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
- Section 10.2.1.2, “Range Optimization”
- Section 10.2.1.22, “Row Constructor Expression Optimization”
- Section 5.6.7, “Searching on Two Keys”
- Section 22.3.4.2, “Select Tables”
- Section 22.4.4.2, “Select Tables”
- Section 5.3.4.2, “Selecting Particular Rows”
- Section 7.1.11, “Server SQL Modes”
- Section 14.8.1, “String Comparison Functions and Operators”