xxhash_32

description

Syntax

INT XXHASH_32(VARCHAR input, ...)

返回输入字符串的32位xxhash值。

注：在计算hash值时，更推荐使用xxhash_32，而不是murmur_hash3_32。

example

1. mysql> select xxhash_32(NULL);
2. +-----------------+
3. | xxhash_32(NULL) |
4. +-----------------+
5. |            NULL |
6. +-----------------+

8. mysql> select xxhash_32("hello");
9. +--------------------+
10. | xxhash_32('hello') |
11. +--------------------+
12. |          -83855367 |
13. +--------------------+

15. mysql> select xxhash_32("hello", "world");
16. +-----------------------------+
17. | xxhash_32('hello', 'world') |
18. +-----------------------------+
19. |                  -920844969 |
20. +-----------------------------+

keywords

HASH_32,HASH