Doc Menu

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

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