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