BIT_COUNT(N)

MySQL 8.4

Returns the number of bits that are set in the argument N as an unsigned 64-bit integer, or NULL if the argument is NULL.

Syntax

MYSQL

SELECT BIT_COUNT(64), BIT_COUNT(BINARY 64);
1, 7
SELECT BIT_COUNT('64'), BIT_COUNT(_binary '64');
1, 7
SELECT BIT_COUNT(X'40'), BIT_COUNT(_binary X'40');
1, 1

Examples

Example

MYSQL

SELECT BIT_COUNT(64), BIT_COUNT(BINARY 64);
1, 7
SELECT BIT_COUNT('64'), BIT_COUNT(_binary '64');
1, 7
SELECT BIT_COUNT(X'40'), BIT_COUNT(_binary X'40');
1, 1