SingleStore DB

bitwise left shift (<<)

Moves all of the bits of num1 to the left by num2 places. Each place shifted is equivalent to multiplying by 2.

Syntax
num1 << num2
Return Type

Integer

Examples
SELECT 8<<1, bin(8), bin(8<<1);
+------+--------+-----------+
| 8<<1 | bin(8) | bin(8<<1) |
+------+--------+-----------+
|   16 | 1000   | 10000     |
+------+--------+-----------+

SELECT 7<<1, bin(7), bin(7<<1);
+------+--------+-----------+
| 7<<1 | bin(7) | bin(7<<1) |
+------+--------+-----------+
|   14 | 111    | 1110      |
+------+--------+-----------+