xxhash_32

description

Syntax

INT XXHASH_32(VARCHAR input, ...)

Return the 32 bits xxhash of input string.

Note: When calculating hash values, it is more recommended to use xxhash_32 instead of 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

XXHASH_32,HASH