bitnot
Description
Returns the bitwise negation of a numeric expression.
Syntax
BITNOT(x);
Parameters
x
: This expression must evaluate to any of the following data types: TINYINT, SMALLINT, INT, BIGINT, LARGEINT.
Return value
The return value has the same type as x
. If any value is NULL, the result is NULL.
Examples
mysql> select bitnot(3);
+-----------+
| bitnot(3) |
+-----------+
| -4 |
+-----------+