MySQL (Part 5)

MySQL (Part 5)

1. bitwise operators

Bitwise operators are used to test, shift, or test bitwise in binary bytes. The bitwise operators provided in MySQL include: bitwise OR (|), bitwise AND (&), shift by bit or (^), shift by bit left (<), shift by bit right (>), and reverse by bit (~)

Operator	Function
|	Bit or
&	Bitwise AND
^	Bitwise OR
<	Shift left
>	Shift right
~	Bitwise Inversion

Bit or (|)

Select 10 | 15, 9 | 4 | 2;

Bit and (&)

Select 10 & 15, 9 & 4 & 2;

Bitwise OR (^)

Select 10 ^ 15,1 ^ 0, 1 ^ 1;

Shift left (<)

Select 1 <2, 4 <2;

Shift right (>)

Select 1> 1, 16> 2;

Bitwise inversion (~)

Select 5 &~ 1;

The value after the bitwise operation of MySQL is a 64-bit unsigned number. The binary value of 1 indicates that the rightmost bit is 1, and the other bits are all 0, the other bits are 1.

Select bin (~ 1 );