| title | Bit Functions and Operators | ||
|---|---|---|---|
| summary | Learn about the bit functions and operators. | ||
| aliases |
|
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 |