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