The >> is the right shift operator : Bit « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. Bit

The >> is the right shift operator

     
mysql>
mysql> SELECT 3 >> 1;
+--------+
| 3 >> 1 |
+--------+
|      1 |
+--------+
1 row in set (0.00 sec)

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

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

mysql>








Related examples in the same category

1.UPDATE statement moves each bit to the left one position:
2.left 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.