<<

Shifts a longlong (BIGINT) number or binary string to the left.

Syntax

MYSQL Copy

SELECT 1 << 2;
4
SELECT HEX(_binary X'00FF00FF00FF' << 8);
'FF00FF00FF00'

Examples

Example

The result type depends on whether the bit argument is evaluated as a binary string or number:

MYSQL Copy

SELECT 1 << 2;
4
SELECT HEX(_binary X'00FF00FF00FF' << 8);
'FF00FF00FF00'