Skip to content

~

运算符说明

一元运算符,二进制取反。对每一个比特位执行非(NOT)操作。NOT a 结果为 a 的反转(即反码),参数只能是数字或 NULL。

语法结构

> SELECT ~value1;

示例

mysql> select ~-5;
+--------+
| ~ (-5) |
+--------+
|      4 |
+--------+
1 row in set (0.00 sec)

mysql> select ~null;
+-------+
| ~null |
+-------+
|  NULL |
+-------+
1 row in set (0.00 sec)

mysql> select ~a, ~b from t1;
+------+----------------------+
| ~a   | ~b                   |
+------+----------------------+
|    0 | 18446744073709551614 |
|    4 | 18446744073709551610 |
+------+----------------------+
2 rows in set (0.00 sec)