bitwise left shift (<<)
On this page
Moves all of the bits of num1 to the left by num2 places.
Syntax
num1 << num2Return 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