Important

You are viewing the documentation of an older version of the TiDB database (TiDB v2.1).

It is recommended that you use the latest stable version of the TiDB database.

Encryption and Compression Functions

NameDescription
MD5()Calculate MD5 checksum
PASSWORD()Calculate and return a password string
RANDOM_BYTES()Return a random byte vector
SHA1(), SHA()Calculate an SHA-1 160-bit checksum
SHA2()Calculate an SHA-2 checksum
AES_DECRYPT()Decrypt using AES
AES_ENCRYPT()Encrypt using AES
COMPRESS()Return result as a binary string
UNCOMPRESS()Uncompress a string compressed
UNCOMPRESSED_LENGTH()Return the length of a string before compression
CREATE_ASYMMETRIC_PRIV_KEY()Create private key
CREATE_ASYMMETRIC_PUB_KEY()Create public key
CREATE_DH_PARAMETERS()Generate shared DH secret
CREATE_DIGEST()Generate digest from string
ASYMMETRIC_DECRYPT()Decrypt ciphertext using private or public key
ASYMMETRIC_DERIVE()Derive symmetric key from asymmetric keys
ASYMMETRIC_ENCRYPT()Encrypt cleartext using private or public key
ASYMMETRIC_SIGN()Generate signature from digest
ASYMMETRIC_VERIFY()Verify that signature matches digest