Operator Index
   

Operator Index

!

Section 8.5, “Expression Синтаксис”
Section 11.3.3, “Logical Operators”
Section 11.3.1, “Operator Precedence”

!=

Section 11.3.2, “Comparison Functions and Operators”
Section 11.3.1, “Operator Precedence”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”

%

Section 11.6.1, “Arithmetic Operators”

&

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 11.12, “Bit Functions”
Section 17.5, “Restrictions and Limitations on Partitioning”

&&

Section 11.3.3, “Logical Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”

*

Section 11.6.1, “Arithmetic Operators”
Section 10.1.1, “Numeric Type Overview”
Section 17.5, “Restrictions and Limitations on Partitioning”

+

Section 11.6.1, “Arithmetic Operators”
Section 11.10, “Cast Functions and Operators”
Section 11.7, “Date and Time Functions”
Section 10.1.1, “Numeric Type Overview”
Section 17.5, “Restrictions and Limitations on Partitioning”

-

Section 11.6.1, “Arithmetic Operators”
Section 11.10, “Cast Functions and Operators”
Section 11.7, “Date and Time Functions”
Section 10.1.1, “Numeric Type Overview”
Section 17.5, “Restrictions and Limitations on Partitioning”

/

Section 11.6.1, “Arithmetic Operators”
Section 17.5, “Restrictions and Limitations on Partitioning”
Section 5.1.3, “Server System Variables”

<

Section 7.8.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.3.8, “Comparison of B-Tree and Hash Indexes”
Section 7.3.1, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 3.3.4.6, “Working with NULL Values”

<<

Section 11.12, “Bit Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 17.5, “Restrictions and Limitations on Partitioning”

<=

Section 7.8.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.3.8, “Comparison of B-Tree and Hash Indexes”
Section 7.3.1, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”

<=>

Section 7.8.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 11.2, “Type Conversion in Expression Evaluation”

<>

Section 7.8.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 3.3.4.6, “Working with NULL Values”

=

Section 7.8.2, “EXPLAIN Output Format”
Section 12.7.4, “SET Синтаксис”
Section 11.3.4, “Assignment Operators”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.3.8, “Comparison of B-Tree and Hash Indexes”
Section 7.3.1, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section E.4, “Restrictions on Subqueries”
Section 11.5.1, “String Comparison Functions”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 8.4, “User-Defined Variables”
Section 3.3.4.6, “Working with NULL Values”

>

Section 7.8.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.3.8, “Comparison of B-Tree and Hash Indexes”
Section 7.3.1, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”

>=

Section 7.8.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.3.8, “Comparison of B-Tree and Hash Indexes”
Section 7.3.1, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”

>>

Section 11.12, “Bit Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 17.5, “Restrictions and Limitations on Partitioning”

AND

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 7.3.8, “Comparison of B-Tree and Hash Indexes”
Section 7.3.1, “How MySQL Uses Indexes”
Section 7.13.2, “Index Merge Optimization”
Section 11.3.3, “Logical Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.13.12, “Optimizing IN/=ANY Subqueries”
Section E.4, “Restrictions on Subqueries”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 11.5.1, “String Comparison Functions”
Section 7.13.2.1, “The Index Merge Intersection Access Algorithm”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 18.5.2, “View Processing Algorithms”
Section 1.4, “What Is New in MySQL 5.5”

BETWEEN

Section 7.8.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.3.8, “Comparison of B-Tree and Hash Indexes”
Section 7.3.1, “How MySQL Uses Indexes”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 11.2, “Type Conversion in Expression Evaluation”

BINARY

Section 11.10, “Cast Functions and Operators”
Section 3.3.4.7, “Pattern Matching”
Section 3.3.4.4, “Sorting Rows”
Section 9.1.7.7, “The BINARY Operator”

BINARY str

Section 11.10, “Cast Functions and Operators”

CASE

Section 12.6.5.1, “CASE Синтаксис”
Section 11.4, “Control Flow Functions”
Section 8.5, “Expression Синтаксис”
Section 1.8.4, “MySQL Extensions to Standard SQL”

CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END

Section 11.4, “Control Flow Functions”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 11.4, “Control Flow Functions”

CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [ELSE result] END

Section 11.4, “Control Flow Functions”

DIV

Section 11.6.1, “Arithmetic Operators”
Section 17.5, “Restrictions and Limitations on Partitioning”

IS

Section 11.3.1, “Operator Precedence”

IS NOT NULL

Section 11.3.2, “Comparison Functions and Operators”
Section C.5.5.3, “Problems with NULL Values”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 3.3.4.6, “Working with NULL Values”

IS NOT boolean_value

Section 11.3.2, “Comparison Functions and Operators”

IS NULL

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.4, “IS NULL Optimization”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.13.12, “Optimizing IN/=ANY Subqueries”
Section C.5.5.3, “Problems with NULL Values”
Section 5.1.3, “Server System Variables”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 3.3.4.6, “Working with NULL Values”

IS boolean_value

Section 11.3.2, “Comparison Functions and Operators”

LIKE

Section 12.7.5.4, “SHOW CHARACTER SET Синтаксис”
Section 12.7.5.5, “SHOW COLLATION Синтаксис”
Section 12.7.5.6, “SHOW COLUMNS Синтаксис”
Section 12.7.5.15, “SHOW DATABASES Синтаксис”
Section 12.7.5.19, “SHOW EVENTS Синтаксис”
Section 12.7.5.25, “SHOW OPEN TABLES Синтаксис”
Section 12.7.5.29, “SHOW PROCEDURE STATUS Синтаксис”
Section 12.7.5.36, “SHOW STATUS Синтаксис”
Section 12.7.5.37, “SHOW TABLE STATUS Синтаксис”
Section 12.7.5.38, “SHOW TABLES Синтаксис”
Section 12.7.5.39, “SHOW TRIGGERS Синтаксис”
Section 12.7.5.40, “SHOW VARIABLES Синтаксис”
Section 9.1.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 11.10, “Cast Functions and Operators”
Section 7.3.8, “Comparison of B-Tree and Hash Indexes”
Section 20.2.3.2.1, “Event Pre-Filtering”
Section 19.32, “Extensions to SHOW Statements”
Section 7.3.1, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 3.3.4.7, “Pattern Matching”
Section 16.5.8, “Quick Reference: MySQL Cluster SQL Statements”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.4.3, “Specifying Account Names”
Section 11.5.1, “String Comparison Functions”
Section 8.1.1, “String Literals”
Section 5.1.4.1, “Structured System Variables”
Section 10.4.5, “The SET Type”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 5.1.4, “Using System Variables”

LIKE 'pattern'

Section 12.7.5, “SHOW Синтаксис”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”

LIKE ... ESCAPE

Section C.5.8, “Known Issues in MySQL”

N % M

Section 11.6.1, “Arithmetic Operators”
Section 11.6.2, “Mathematical Functions”

N MOD M

Section 11.6.1, “Arithmetic Operators”
Section 11.6.2, “Mathematical Functions”

NOT

Section 11.3.3, “Logical Operators”
Section 5.1.6, “Server SQL Modes”

NOT LIKE

Section 3.3.4.7, “Pattern Matching”
Section 11.5.1, “String Comparison Functions”

NOT REGEXP

Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 3.3.4.7, “Pattern Matching”
Section 11.5.1, “String Comparison Functions”

NOT RLIKE

Section 3.3.4.7, “Pattern Matching”
Section 11.5.1, “String Comparison Functions”

OR

Section 12.7.1.3, “GRANT Синтаксис”
Section 8.5, “Expression Синтаксис”
Section 7.13.2, “Index Merge Optimization”
Section 11.3.3, “Logical Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.13.12, “Optimizing IN/=ANY Subqueries”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 5.1.6, “Server SQL Modes”
Section 11.5.1, “String Comparison Functions”
Section 7.13.2.3, “The Index Merge Sort-Union Access Algorithm”
Section 7.13.2.2, “The Index Merge Union Access Algorithm”
Section 7.13.1.2, “The Range Access Method for Multiple-Часть Indexes”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 1.4, “What Is New in MySQL 5.5”

REGEXP

Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 3.3.4.7, “Pattern Matching”
Section 11.5.2, “Regular Expressions”
Section E.7, “Restrictions on Character Sets”

RLIKE

Section 3.3.4.7, “Pattern Matching”
Section 11.5.2, “Regular Expressions”
Section E.7, “Restrictions on Character Sets”

XOR

Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 11.3.3, “Logical Operators”

^

Section 11.12, “Bit Functions”
Section 8.5, “Expression Синтаксис”
Section 11.3.1, “Operator Precedence”
Section 17.5, “Restrictions and Limitations on Partitioning”

expr BETWEEN min AND max

Section 11.3.2, “Comparison Functions and Operators”

expr LIKE pat [ESCAPE 'escape_char']

Section 11.5.1, “String Comparison Functions”

expr NOT BETWEEN min AND max

Section 11.3.2, “Comparison Functions and Operators”

expr NOT LIKE pat [ESCAPE 'escape_char']

Section 11.5.1, “String Comparison Functions”

expr NOT REGEXP pat

Section 11.5.2, “Regular Expressions”

expr NOT RLIKE pat

Section 11.5.2, “Regular Expressions”

expr REGEXP pat

Section 11.5.2, “Regular Expressions”

expr RLIKE pat

Section 11.5.2, “Regular Expressions”

expr1 SOUNDS LIKE expr2

Section 11.5, “String Functions”

|

Section 11.12, “Bit Functions”
Section 17.5, “Restrictions and Limitations on Partitioning”

||

Section 9.1.7.3, “COLLATE Clause Precedence”
Section 8.5, “Expression Синтаксис”
Section 11.3.3, “Logical Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 9.1.9.1, “Result Strings”
Section 5.1.6, “Server SQL Modes”

~

Section 11.12, “Bit Functions”
Section 17.5, “Restrictions and Limitations on Partitioning”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices
   
JOIN Types Index Начало Option Index
    Поддержать сайт на родительском проекте КГБ