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      |
+------+--------+-----------+

Last modified: February 24, 2023

Was this article helpful?