📣

TiDB Cloud Essential is now in public preview. Try it out →

Important

You are viewing the documentation of an older version of the TiDB database (TiDB v5.4). It is recommended that you use the latest LTS version of the TiDB database.

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

Bit Functions and Operators

Was this page helpful?