murmur_hash3_64

description

Syntax

BIGINT MURMUR_HASH3_64(VARCHAR input, ...)

返回输入字符串的64位murmur3 hash值

example

  1. mysql> select murmur_hash3_64(null);
  2. +-----------------------+
  3. | murmur_hash3_64(NULL) |
  4. +-----------------------+
  5. |                  NULL |
  6. +-----------------------+
  8. mysql> select murmur_hash3_64("hello");
  9. +--------------------------+
  10. | murmur_hash3_64('hello') |
  11. +--------------------------+
  12. |     -3215607508166160593 |
  13. +--------------------------+
  15. mysql> select murmur_hash3_64("hello", "world");
  16. +-----------------------------------+
  17. | murmur_hash3_64('hello', 'world') |
  18. +-----------------------------------+
  19. |               3583109472027628045 |
  20. +-----------------------------------+

keywords

  1. MURMUR_HASH3_64,HASH