~

Description

Invert all bits.

The result type depends on whether the bit argument is evaluated as a binary string or number:

  • Binary-string evaluation occurs when the bit argument has a binary string type, and is not a hexadecimal literal, bit literal, or NULL literal. Numeric evaluation occurs otherwise, with argument conversion to an unsigned 64-bit integer as necessary.

  • Binary-string evaluation produces a binary string of the same length as the bit argument. Numeric evaluation produces an unsigned 64-bit integer.

Syntax

  1. > SELECT value1 ~ value2;

Examples

  1. mysql> select ~-5;
  2. +--------+
  3. | ~ (-5) |
  4. +--------+
  5. |      4 |
  6. +--------+
  7. 1 row in set (0.00 sec)
  9. mysql> select ~null;
  10. +-------+
  11. | ~null |
  12. +-------+
  13. |  NULL |
  14. +-------+
  15. 1 row in set (0.00 sec)
  17. mysql> select ~a, ~b from t1;
  18. +------+----------------------+
  19. | ~a   | ~b                   |
  20. +------+----------------------+
  21. |    0 | 18446744073709551614 |
  22. |    4 | 18446744073709551610 |
  23. +------+----------------------+
  24. 2 rows in set (0.00 sec)