Skip to main content

bitnot

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 |
+-----------+