Move the binary value 11 three bits to the left. : Bit « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. Bit

Move the binary value 11 three bits to the left.

     
mysql>
mysql> SELECT B'11' << 3;
+------------+
| B'11' << 3 |
+------------+
|         24 |
+------------+
1 row in set (0.00 sec)

mysql>
mysql>








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 Operators
6.Bit operation
7.Bit or
8.Left shift
9.Left shift 3
10.The result of a bitwise AND between 7 and 9 is 1
11.Shifting beyond 64 bits, or with a negative number, just returns 0.
12.Apply several binary operators to the columns of the MATCHES table.