bitwise NOT (~)
On this page
Inverts all of the bits of a given number.
This operator is unary, ie, it applies to only one argument.
Syntax
~numReturn Type
Integer
Examples
SELECT ~8, bin(8), bin(~8);
+----------------------+--------+------------------------------------------------------------------+
| ~8 | bin(8) | bin(~8) |
+----------------------+--------+------------------------------------------------------------------+
| 18446744073709551607 | 1000 | 1111111111111111111111111111111111111111111111111111111111110111 |
+----------------------+--------+------------------------------------------------------------------+Last modified: February 24, 2023