Bit Functions and Operators

TiDB supports all of the bit functions and operators available in MySQL 5.7.

Bit functions and operators

NameDescription
BIT_COUNT()Return the number of bits that are set as 1
&Bitwise AND
~Bitwise inversion
|Bitwise OR
^Bitwise XOR
<<Left shift
>>Right shift