Bit Functions and Operators
TiDB supports all of the bit functions and operators available in MySQL 5.7.
Bit functions and operators
| Name | Description |
|---|---|
BIT_COUNT() | Return the number of bits that are set as 1 |
| & | Bitwise AND |
| ~ | Bitwise inversion |
| | | Bitwise OR |
| ^ | Bitwise XOR |
| << | Left shift |
| >> | Right shift |