Bit Functions and Operators

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