Hash
#fancy-title-673ee7e516524 a{ color: #274e75; }
MyDiamo for MySQL provides two hash functions. Both of them use UDF form, so they are available regardless of user accounts.
hash_raw_data(‘string_data’)
This function returns SHA256 binary result of string_data.
hash_b64_data(‘string_data’)
This function returns a Base64-applied SHA256 binary result of string_data.
Orange lined part uses hash function.
Hashing can make columns partially encrypted. However, data encrypted by hash functions cannot be decrypted and will only be used in their encrypted form.