Skip to main content
Version: 26.2 Preview

xx_hash64

Returns the 64-bit XXH64 hash value of the input string.

Syntax​

BIGINT XX_HASH64(VARCHAR input, ...)

Examples​

MySQL > select xx_hash64(null);
+-----------------+
| xx_hash64(NULL) |
+-----------------+
|            NULL |
+-----------------+
MySQL > select xx_hash64("hello");
+---------------------+
| xx_hash64('hello')  |
+---------------------+
| 2794345569481354659 |
+---------------------+
MySQL > select xx_hash64("hello", "world");
+-----------------------------+
| xx_hash64('hello', 'world') |
+-----------------------------+
|         8004569595807101537 |
+-----------------------------+

keyword​

XX_HASH64,HASH,XXH64,xxHash