left shift operator : Bit « Function « SQL / MySQL






left shift operator

     
mysql>
mysql> SELECT 2 << 1;
+--------+
| 2 << 1 |
+--------+
|      4 |
+--------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT 15 << 4;
+---------+
| 15 << 4 |
+---------+
|     240 |
+---------+
1 row in set (0.00 sec)

   
    
    
    
    
  








Related examples in the same category

1.UPDATE statement moves each bit to the left one position:
2.The >> is the right shift operator
3.Bitwise operators
4.Bit 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.