SHA2

description

Use SHA2 to digest the message.

Syntax

SHA2(str, digest_length)

Arguments

• str: content to be encrypted
• digest_length: the length of the digest

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