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