в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:49:40Z

1 версия

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

== COALESCE(value,...) returns the first non-NULL value in the list, or NULL if there are no non-NULL values==



<source lang="sql">
mysql>
mysql> SELECT COALESCE(NULL,1);
+------------------+
| COALESCE(NULL,1) |
+------------------+
| 1 |
+------------------+
1 row in set (0.00 sec)
mysql>
mysql></source>

== expr BETWEEN min AND max==

expr NOT BETWEEN min AND max is the same as NOT (expr BETWEEN min AND max).
If expr is greater than or equal to min and expr is less than or equal to max, BETWEEN returns 1.
Otherwise it returns 0.
This is equivalent to the expression (min <= expr AND expr <= max).



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

== SELECT 2 BETWEEN 2 AND "3";==



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

== SELECT 2 BETWEEN 2 AND "x-3";==



<source lang="sql">
mysql>
mysql> SELECT 2 BETWEEN 2 AND "x-3";
+-----------------------+
| 2 BETWEEN 2 AND "x-3" |
+-----------------------+
| 0 |
+-----------------------+
1 row in set, 1 warning (0.01 sec)
mysql></source>

== SELECT "b" BETWEEN "a" AND "c";==



<source lang="sql">
mysql>
mysql> SELECT "b" BETWEEN "a" AND "c";
+-------------------------+
| "b" BETWEEN "a" AND "c" |
+-------------------------+
| 1 |
+-------------------------+
1 row in set (0.00 sec)
mysql></source>

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

MySQL Tutorial/Comparison Functions Operators/BETWEEN AND - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия