Bit Functions and Operators

z
y
T
q

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
Bit Functions and Operatorswas last updated 12/28/2022, 3:36:17 AM: v6.5: remove aliases (#11751)

Was this page helpful?