bitnot

description

Syntax

BITNOT(Integer-type value)

Returns the result of the NOT operation of one integer.

Integer range: TINYINT、SMALLINT、INT、BIGINT、LARGEINT

example

1. mysql> select bitnot(7) ans;
2. +------+
3. | ans  |
4. +------+
5. |   -8 |
6. +------+

8. mysql> select bitxor(-127) ans;
9. +------+
10. | ans  |
11. +------+
12. |  126 |
13. +------+

keyword

1. BITNOT