MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Symbols | A | B | C | D | E | I | L | M | N | O | R | V | X
-
!
!=
&
&&
>
- Section 12.3.2, “Comparison Functions and Operators”
- Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 12.3.1, “Operator Precedence”
- Section 8.3.11, “Optimizer Use of Generated Column Indexes”
- Section 8.2.1.2, “Range Optimization”
- Section 11.6, “The JSON Data Type”
->
>>
->>
>=
- Section 12.3.2, “Comparison Functions and Operators”
- Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 12.3.1, “Operator Precedence”
- Section 8.3.11, “Optimizer Use of Generated Column Indexes”
- Section 8.2.1.2, “Range Optimization”
- Section 11.6, “The JSON Data Type”
<
- Section 12.3.2, “Comparison Functions and Operators”
- Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 12.3.1, “Operator Precedence”
- Section 8.3.11, “Optimizer Use of Generated Column Indexes”
- Section 8.2.1.2, “Range Optimization”
- Section 11.6, “The JSON Data Type”
- Section 3.3.4.6, “Working with NULL Values”
<>
<<
<=
- Section 12.3.2, “Comparison Functions and Operators”
- Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 12.3.1, “Operator Precedence”
- Section 8.3.11, “Optimizer Use of Generated Column Indexes”
- Section 8.2.1.2, “Range Optimization”
- Section 11.6, “The JSON Data Type”
<=>
- Section 12.3.2, “Comparison Functions and Operators”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 12.3.1, “Operator Precedence”
- Section 8.2.1.2, “Range Optimization”
- Section 11.6, “The JSON Data Type”
- Section 12.2, “Type Conversion in Expression Evaluation”
*
+
/
:=
=
- Section 12.3.4, “Assignment Operators”
- Section 12.3.2, “Comparison Functions and Operators”
- Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 12.3.1, “Operator Precedence”
- Section 8.3.11, “Optimizer Use of Generated Column Indexes”
- Section 8.2.1.2, “Range Optimization”
- Section C.4, “Restrictions on Subqueries”
- Section 13.7.5.1, “SET Syntax for Variable Assignment”
- Section 12.5.1, “String Comparison Functions”
- Section 11.6, “The JSON Data Type”
- Section 9.4, “User-Defined Variables”
- Section 3.3.4.6, “Working with NULL Values”
^
|
||
- Section 12.5.3, “Character Set and Collation of Function Results”
- Section 10.8.2, “COLLATE Clause Precedence”
- Section 9.5, “Expressions”
- Section 12.3.3, “Logical Operators”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 12.3.1, “Operator Precedence”
- Section 5.1.11, “Server SQL Modes”
- Section 1.4, “What Is New in MySQL 8.0”
~
AND
- Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 13.1.20, “CREATE TABLE Syntax”
- Section 8.2.1.3, “Index Merge Optimization”
- Section 12.3.3, “Logical Operators”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 8.2.2.1, “Optimizing IN and EXISTS Subquery predicates with Semi-Join Transformations”
- Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
- Section 8.2.1.2, “Range Optimization”
- Section C.4, “Restrictions on Subqueries”
- Section 8.2.1.21, “Row Constructor Expression Optimization”
- Section 3.6.7, “Searching on Two Keys”
- Section 20.3.4.2, “Select Tables”
- Section 20.4.4.2, “Select Tables”
- Section 3.3.4.2, “Selecting Particular Rows”
- Section 12.5.1, “String Comparison Functions”
- Section 24.5.2, “View Processing Algorithms”
- Section 1.4, “What Is New in MySQL 8.0”
BETWEEN
- Section 12.3.2, “Comparison Functions and Operators”
- Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 8.2.1.12, “Condition Filtering”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 8.3.11, “Optimizer Use of Generated Column Indexes”
- Section 8.2.1.2, “Range Optimization”
- Section 11.6, “The JSON Data Type”
- Section 12.2, “Type Conversion in Expression Evaluation”
BINARY
CASE
CASE value WHEN END
CASE WHEN END
CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END
column->>path
DIV
expr BETWEEN min AND max
expr LIKE pat
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()
IS boolean_value
IS NOT boolean_value
IS NOT NULL
IS NULL
- Section 12.3.2, “Comparison Functions and Operators”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 8.2.1.14, “IS NULL Optimization”
- Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
- Section B.4.4.3, “Problems with NULL Values”
- Section 8.2.1.2, “Range Optimization”
- Section 5.1.8, “Server System Variables”
- Section 3.3.4.6, “Working with NULL Values”
LIKE
- Section 6.2.7, “Access Control, Stage 2: Request Verification”
- Section 12.10, “Cast Functions and Operators”
- Section 10.2, “Character Sets and Collations in MySQL”
- Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 25.42, “Extensions to SHOW Statements”
- Section 12.17.3, “Functions That Search JSON Values”
- Section 13.8.3, “HELP Syntax”
- Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 4.5.1.4, “mysql Client Server-Side Help”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 22.6.11, “NDB Cluster Replication Conflict Resolution”
- Section 12.3.1, “Operator Precedence”
- Section 3.3.4.7, “Pattern Matching”
- Section 26.4.4, “Pre-Filtering by Instrument”
- Section 22.5.9, “Quick Reference: NDB Cluster SQL Statements”
- Section 8.2.1.2, “Range Optimization”
- Section 17.1.6.3, “Replication Slave Options and Variables”
- Section 13.7.6.3, “SHOW CHARACTER SET Syntax”
- Section 13.7.6.4, “SHOW COLLATION Syntax”
- Section 13.7.6.5, “SHOW COLUMNS Syntax”
- Section 13.7.6.14, “SHOW DATABASES Syntax”
- Section 13.7.6.18, “SHOW EVENTS Syntax”
- Section 13.7.6.24, “SHOW OPEN TABLES Syntax”
- Section 13.7.6.28, “SHOW PROCEDURE STATUS Syntax”
- Section 13.7.6.35, “SHOW STATUS Syntax”
- Section 13.7.6.36, “SHOW TABLE STATUS Syntax”
- Section 13.7.6.37, “SHOW TABLES Syntax”
- Section 13.7.6.38, “SHOW TRIGGERS Syntax”
- Section 13.7.6.39, “SHOW VARIABLES Syntax”
- Section 6.2.4, “Specifying Account Names”
- Section 12.5.1, “String Comparison Functions”
- Section 9.1.1, “String Literals”
- Section 5.1.9.5, “Structured System Variables”
- Section 11.4.1, “The CHAR and VARCHAR Types”
- Section 27.4.4.5, “The ps_setup_disable_consumer() Procedure”
- Section 27.4.4.6, “The ps_setup_disable_instrument() Procedure”
- Section 27.4.4.9, “The ps_setup_enable_consumer() Procedure”
- Section 27.4.4.10, “The ps_setup_enable_instrument() Procedure”
- Section 11.4.5, “The SET Type”
- Section 5.1.9, “Using System Variables”
LIKE ... ESCAPE
MEMBER OF()
NOT
NOT REGEXP
OR
- Section 9.5, “Expressions”
- Section 13.7.1.6, “GRANT Syntax”
- Section 8.2.1.3, “Index Merge Optimization”
- Section 12.3.3, “Logical Operators”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 12.3.1, “Operator Precedence”
- Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
- Section 8.2.1.2, “Range Optimization”
- Section 8.2.1.21, “Row Constructor Expression Optimization”
- Section 3.6.7, “Searching on Two Keys”
- Section 20.3.4.2, “Select Tables”
- Section 20.4.4.2, “Select Tables”
- Section 3.3.4.2, “Selecting Particular Rows”
- Section 5.1.11, “Server SQL Modes”
- Section 12.5.1, “String Comparison Functions”
- Section 1.4, “What Is New in MySQL 8.0”