MySQL 5.6 Release Notes
Symbols | A | B | C | D | E | I | L | N | O | R | X
-
!
!=
&
>
>>
>=
<
- Section 12.4.2, “Comparison Functions and Operators”
- Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 12.4.1, “Operator Precedence”
- Section 8.2.1.2, “Range Optimization”
- Section 3.3.4.6, “Working with NULL Values”
<>
<<
<=
<=>
*
+
/
:=
=
- Section 12.4.4, “Assignment Operators”
- Section 12.4.2, “Comparison Functions and Operators”
- Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 12.4.1, “Operator Precedence”
- Section 8.2.1.2, “Range Optimization”
- Section 13.2.10.12, “Restrictions on Subqueries”
- Section 13.7.4.1, “SET Syntax for Variable Assignment”
- Section 12.8.1, “String Comparison Functions and Operators”
- Section 9.4, “User-Defined Variables”
- Section 3.3.4.6, “Working with NULL Values”
^
|
||
~
AND
- Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
- Section 13.1.17, “CREATE TABLE Statement”
- Section 8.2.1.3, “Index Merge Optimization”
- Section 12.4.3, “Logical Operators”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 8.2.2.1, “Optimizing Subqueries with Semijoin Transformations”
- Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
- Section 8.2.1.2, “Range Optimization”
- Section 13.2.10.12, “Restrictions on Subqueries”
- Section 8.2.1.18, “Row Constructor Expression Optimization”
- Section 3.6.7, “Searching on Two Keys”
- Section 3.3.4.2, “Selecting Particular Rows”
- Section 12.8.1, “String Comparison Functions and Operators”
- Section 20.5.2, “View Processing Algorithms”
BETWEEN
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
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()
IS boolean_value
IS NOT boolean_value
IS NOT NULL
IS NULL
- Section 12.4.2, “Comparison Functions and Operators”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 8.2.1.12, “IS NULL Optimization”
- Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
- Section B.3.4.3, “Problems with NULL Values”
- Section 8.2.1.2, “Range Optimization”
- Section 5.1.7, “Server System Variables”
- Section 3.3.4.6, “Working with NULL Values”
LIKE
- Section 6.2.6, “Access Control, Stage 2: Request Verification”
- Section 12.11, “Cast Functions and Operators”
- Section 10.2, “Character Sets and Collations in MySQL”
- Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
- Section 8.8.2, “EXPLAIN Output Format”
- Section 21.9, “Extensions to SHOW Statements”
- Section 13.8.3, “HELP Statement”
- Section A.11, “MySQL 5.6 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 4.5.1.4, “mysql Client Server-Side Help”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 18.7.4, “NDB Cluster Replication Schema and Tables”
- Section 12.4.1, “Operator Precedence”
- Section 3.3.4.7, “Pattern Matching”
- Section 22.4.4, “Pre-Filtering by Instrument”
- Section 18.6.15, “Quick Reference: NDB Cluster SQL Statements”
- Section 8.2.1.2, “Range Optimization”
- Section 17.1.4.3, “Replica Server Options and Variables”
- Section 5.1.10, “Server SQL Modes”
- Section 13.7.5.4, “SHOW CHARACTER SET Statement”
- Section 13.7.5.5, “SHOW COLLATION Statement”
- Section 13.7.5.6, “SHOW COLUMNS Statement”
- Section 13.7.5.15, “SHOW DATABASES Statement”
- Section 13.7.5.19, “SHOW EVENTS Statement”
- Section 13.7.5.25, “SHOW OPEN TABLES Statement”
- Section 13.7.5.29, “SHOW PROCEDURE STATUS Statement”
- Section 13.7.5.36, “SHOW STATUS Statement”
- Section 13.7.5.37, “SHOW TABLE STATUS Statement”
- Section 13.7.5.38, “SHOW TABLES Statement”
- Section 13.7.5.39, “SHOW TRIGGERS Statement”
- Section 13.7.5.40, “SHOW VARIABLES Statement”
- Section 6.2.4, “Specifying Account Names”
- Section 12.8.1, “String Comparison Functions and Operators”
- Section 9.1.1, “String Literals”
- Section 5.1.8.3, “Structured System Variables”
- Section 11.3.2, “The CHAR and VARCHAR Types”
- Section 11.3.6, “The SET Type”
- Section 5.1.8, “Using System Variables”
LIKE ... ESCAPE
NOT LIKE
NOT REGEXP
NOT RLIKE
OR
- Section 9.5, “Expressions”
- Section 13.7.1.4, “GRANT Statement”
- Section 8.2.1.3, “Index Merge Optimization”
- Section 12.4.3, “Logical Operators”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 12.4.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.18, “Row Constructor Expression Optimization”
- Section 3.6.7, “Searching on Two Keys”
- Section 3.3.4.2, “Selecting Particular Rows”
- Section 5.1.10, “Server SQL Modes”
- Section 12.8.1, “String Comparison Functions and Operators”