Bit Operators : Bit « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. Bit

Bit Operators

     

Operator          Syntax       Description
 
&                 a & b        Bitwise AND 
 
|                 a | b        Bitwise OR 
 
<<                a << b       Left shift of a by b bit positions
 
>>                a >> b       Right shift of a by b bit positions








Related examples in the same category

1.UPDATE statement moves each bit to the left one position:
2.left shift operator
3.The >> is the right shift operator
4.Bitwise operators
5.Bit operation
6.Bit or
7.Left shift
8.Left shift 3
9.The result of a bitwise AND between 7 and 9 is 1
10.Shifting beyond 64 bits, or with a negative number, just returns 0.
11.Move the binary value 11 three bits to the left.
12.Apply several binary operators to the columns of the MATCHES table.