SHA2

description

使用SHA2对信息进行摘要处理。

Syntax

SHA2(str, digest_length)

Arguments

  • str: 待加密的内容
  • digest_length: 摘要长度

example

  1. mysql> select sha2('abc', 224);
  2. +----------------------------------------------------------+
  3. | sha2('abc', 224)                                         |
  4. +----------------------------------------------------------+
  5. | 23097d223405d8228642a477bda255b32aadbce4bda0b3f7e36c9da7 |
  6. +----------------------------------------------------------+
  7. 1 row in set (0.13 sec)
  9. mysql> select sha2('abc', 384);
  10. +--------------------------------------------------------------------------------------------------+
  11. | sha2('abc', 384)                                                                                 |
  12. +--------------------------------------------------------------------------------------------------+
  13. | cb00753f45a35e8bb5a03d699ac65007272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358baeca134c825a7 |
  14. +--------------------------------------------------------------------------------------------------+
  15. 1 row in set (0.13 sec)
  17. mysql> select sha2(NULL, 512);
  18. +-----------------+
  19. | sha2(NULL, 512) |
  20. +-----------------+
  21. | NULL            |
  22. +-----------------+
  23. 1 row in set (0.09 sec)

keywords

  1. SHA2