Mega Code Archive

 

Categories / MySQL / Function

 

Shifting beyond 64 bits, or with a negative number, just returns 0

mysql> mysql> SELECT 3 << 64; +---------+ | 3 << 64 | +---------+ |       0 | +---------+ 1 row in set (0.00 sec)