Go to the first, previous, next, last section, table of contents.


Bit functions.

These have a range of maximum 64 bits because MySQL uses bigint (64 bit) arithmetic.

|
Bitwise OR.
mysql> select 29 | 15;                   ->     31
&
Bitwise and.
mysql> select 29 & 15;                   ->      13
BIT_COUNT()
Number of set bits in an argument.
mysql> select bit_count(29);             ->      4


Go to the first, previous, next, last section, table of contents.