Syntax:
create_digest(digest_type, str)

Creates a digest from the given string using the given digest type, and
returns the digest as a binary string. If digest generation fails, the
result is NULL.

For the legacy version of this function in use before MySQL 8.0.29, see
MySQL Enterprise Encryption Legacy Function Descriptions
(https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-function
s-legacy.html).

The resulting digest string is suitable for use with asymmetric_sign()
and asymmetric_verify(). The component versions of these functions
accept digests but do not require them, as they are capable of handling
data of an arbitrary length.

digest_type is the digest algorithm to be used to generate the digest
string. The supported digest_type values are 'SHA224', 'SHA256',
'SHA384', and 'SHA512' when OpenSSL 1.0.1 is in use. If OpenSSL 1.1.1
is in use, the additional digest_type values 'SHA3-224', 'SHA3-256',
'SHA3-384', and 'SHA3-512' are available.

str is the non-null data string for which the digest is to be
generated.

URL: https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-functions.html

