Outdated Version
You are viewing an older version of this section. View current production version.
bitwise right shift (>>)
Moves all of the bits of num1 to the right by num2 places. Each place shifted is equivalent to dividing by 2. Remainders (the 0.5 when dividing an odd number) are thrown away.
Syntax
num1 >> num2
Return Type
Integer
Examples
memsql> select 8>>1, bin(8), bin(8>>1);
+------+--------+-----------+
| 8>>1 | bin(8) | bin(8>>1) |
+------+--------+-----------+
| 4 | 1000 | 100 |
+------+--------+-----------+
memsql> select 7>>1, bin(7), bin(7>>1);
+------+--------+-----------+
| 7>>1 | bin(7) | bin(7>>1) |
+------+--------+-----------+
| 3 | 111 | 11 |
+------+--------+-----------+