mysql 动态逻辑运算_MySQL 逻辑运算符

+--------+-----+-----------+--------+---------+----------+

| NOT 10 | !10 | NOT (1-1) | !(1-1) | NOT 1+1 | NOT NULL |

+--------+-----+-----------+--------+---------+----------+

| 0      | 0   | 1         | 1      | 0       | NULL     |

+--------+-----+-----------+--------+---------+----------+

2、逻辑与 ( AND 或 && )

(1) 当所有操作数均为非零值、并且不为 NULL 时，所得值为 1

(2) 当一个或多个操作数为 0 时，所得值为 0

(3) 其余情况所得值为 NULL

mysql> SELECT 1 AND -1, 1 && 0, 0 AND NULL, 1 && NULL ;

+----------+--------+------------+-----------+

| 1 AND -1 | 1 && 0 | 0 AND NULL | 1 && NULL |

+----------+--------+------------+-----------+

| 1        | 0      | 0          | NULL      |

+----------&#