Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
bitwise NOT (~)
Inverts all of the bits of a given number. This operator is unary, ie, it applies to only one argument.
Syntax
~num
Return Type
Integer
Examples
SELECT ~8, bin(8), bin(~8);
+----------------------+--------+------------------------------------------------------------------+
| ~8 | bin(8) | bin(~8) |
+----------------------+--------+------------------------------------------------------------------+
| 18446744073709551607 | 1000 | 1111111111111111111111111111111111111111111111111111111111110111 |
+----------------------+--------+------------------------------------------------------------------+
