| title | summary | category |
|---|---|---|
Bit Functions and Operators |
Learn about the bit functions and operators. |
user guide |
In TiDB, the usage of bit functions and operators is similar to MySQL. See Bit Functions and Operators.
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 |