is操作符的语法可以如下所示：
val is boolean_val
here val is the value that we want to test against boolean value.
boolean_val is the boolean value against which the value would be tested and it can be true, false or unknown.
the syntax of is not operator can be as follows −
在这里， val是我们想要与布尔值进行测试的值。
boolean_val 是要对其进行测试的布尔值，它可以是true、false或unknown。
is not 运算符的语法可以如下所示−
val is not boolean_val
在这里， val 是我们想要根据布尔值进行测试的值。
boolean_val 是要根据其进行测试的布尔值，可以是true、false或unknown。
以下mysql语句将演示上述内容−
mysql> select 1 is true, 0 is false, null is unknown;+-----------+------------+-----------------+| 1 is true | 0 is false | null is unknown |+-----------+------------+-----------------+| 1 | 1 | 1 |+-----------+------------+-----------------+1 row in set (0.00 sec)mysql> select 1 is not true, 0 is not false, null is not unknown;+---------------+----------------+---------------------+| 1 is not true | 0 is not false | null is not unknown |+---------------+----------------+---------------------+| 0 | 0 | 0 |+---------------+----------------+---------------------+1 row in set (0.00 sec)mysql> select 0 is not true, 1 is not false, null is not unknown;+---------------+----------------+---------------------+| 0 is not true | 1 is not false | null is not unknown |+---------------+----------------+---------------------+| 1 | 1 | 0 |+---------------+----------------+---------------------+1 row in set (0.00 sec)
以上就是mysql的is和is not运算符有什么用途？的详细内容。