BIT_SHIFT_LEFT

Description

Functions for left shift operations are usually used to perform bit shift operations, which shift all bits of a binary number to the left by a specified number of bits. It is a form of bitwise operation that is often used to process binary data or perform efficient mathematical calculations.

For the maximum value of BIGINT type, 9223372036854775807, a one-bit left shift results in -2.

Syntax

BIT_SHIFT_LEFT( <x>, <bits>)

Parameters

parameter	description
<x>	The number to be shifted
<bits>	The number of bits to shift left. It is an integer that determines how many bits <x> will be shifted left

Return Value

Returns an integer representing the result of a left shift operation.

Examples

select BIT_SHIFT_LEFT(5, 2), BIT_SHIFT_LEFT(-5, 2), BIT_SHIFT_LEFT(9223372036854775807, 1);

+----------------------+-----------------------+----------------------------------------+
| bit_shift_left(5, 2) | bit_shift_left(-5, 2) | bit_shift_left(9223372036854775807, 1) |
+----------------------+-----------------------+----------------------------------------+
|                   20 |                   -20 |                                     -2 |
+----------------------+-----------------------+----------------------------------------+