8 第五章mysql查询技术 mysql运算符

比较
   大于 >
   小于  <
   大于等于  <=
   等于  =
   安全等于  <=>

    IS NULL
    IS NOT NULL

expr between min and max
expr not between min and max
expr in (vale,value2)
expr not in (value1,value2)

&&逻辑与
||或
not 非

算术运算
 +
-
*

mysql> select 1 < 2;
+-------+
| 1 < 2 |
+-------+
|     1 |
+-------+
1 row in set (0.00 sec)

mysql> select 1 between 1 and 123;
+---------------------+
| 1 between 1 and 123 |
+---------------------+
|                   1 |
+---------------------+
1 row in set (0.00 sec)

mysql> select 1212 -  12365;
+---------------+
| 1212 -  12365 |
+---------------+
|        -11153 |
+---------------+
1 row in set (0.00 sec)

mysql>