Hash

Home / Guide / Operation / Hash

Hash

#fancy-title-58d6aabadcc9a 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.