в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:49:29Z

1 версия

Новая страница

== Operator==

Name
Description
AND, &&
Logical AND
BINARY
Cast a string to a binary string
&
Bitwise AND
|
Bitwise OR
^
Bitwise XOR
/
Division operator
DIV
Integer division
<=>
NULL-safe equal to operator
=
Equal operator
>=
Greater than or equal operator
>
Greater than operator
IS NULL
NULL value test
IS
Test a value against a boolean
<<
Left shift
<=
Less than or equal operator
<
Less than operator
LIKE
Simple pattern matching
-
Minus operator
%
Modulo operator
!=, <>
Not equal operator
NOT LIKE
Negation of simple pattern matching
NOT REGEXP
Negation of REGEXP
NOT, !
Negates value
||, OR
Logical OR
+
Addition operator
REGEXP
Pattern matching using regular expressions
>>
Right shift
RLIKE
Synonym for REGEXP
SOUNDS LIKE
Compare sounds
~
Invert bits
*
Times operator
-
Change the sign of the argument
XOR
Logical XOR

== Operator precedences==

<p>Operator precedences are shown in the following list, from lowest precedence to the highest.</p>
<p>Operators that are shown together on a line have the same precedence.</p>
<OL><LI>:=</LI><LI>||, OR, XOR</LI><LI>&&, AND</LI><LI>NOT</LI><LI>BETWEEN, CASE, WHEN, THEN, ELSE</LI><LI>=, <=>, >=, >, <=, <, <>, !=, IS, LIKE, REGEXP, IN</LI><LI>|</LI><LI>&</LI><LI><<, >></LI><LI>-, +</LI><LI>*, /, DIV, %, MOD</LI><LI>^</LI><LI>- (unary minus), ~ (unary bit inversion)</LI><LI>!</LI><LI>BINARY, COLLATE</LI></OL>
1. 4. Operator
1. 4. 1.
<A href="/Tutorial/MySQL/0020__Introduction/Operator.htm">Operator</a>
1. 4. 2.
Operator precedences
1. 4. 3.
<A href="/Tutorial/MySQL/0020__Introduction/Tooverridethisorderandgrouptermsexplicitlyuseparentheses.htm">To override this order and group terms explicitly, use parentheses.</a>

== To override this order and group terms explicitly, use parentheses.==



<source lang="sql">
mysql>
mysql> SELECT 1+2*3;
+-------+
| 1+2*3 |
+-------+
| 7 |
+-------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT (1+2)*3;
+---------+
| (1+2)*3 |
+---------+
| 9 |
+---------+
1 row in set (0.00 sec)
mysql>
mysql></source>

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/Introduction/Operator - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия