HMAC Functions

HMAC_MD5

HMAC_MD5(x, key) Computes the MD5 HMAC of the bytes value x using key as the key.

SELECT HMAC_MD5('foo', 'bar')

SELECT HMAC_MD5('foo', null)

HMAC_SHA1

HMAC_SHA1(x, key) Computes the SHA1 HMAC of the bytes value x using key as the key.

SELECT HMAC_SHA1('foo', 'bar')

SELECT HMAC_SHA1('foo', null)

HMAC_SHA256

HMAC_SHA256(x, key) Computes the SHA256 HMAC of the bytes value x using key as the key.

SELECT HMAC_SHA256('foo', 'bar')

SELECT HMAC_SHA256('foo', null)

HMAC_SHA512

HMAC_SHA512(x, key) Computes the SHA512 HMAC of the bytes value x using key as the key.

SELECT HMAC_SHA512('foo', 'bar')

SELECT HMAC_SHA512('foo', null)

HMAC

HMAC(x, key, digest) Computes the HMAC of the bytes value x using key as the key and digest as the digest method, where digest is is one of the OpenSSL digest methods md5, sha1, sha256, or sha512 (case insensitive).

SELECT HMAC('foo', 'bar', 'md5')

SELECT HMAC('foo', 'bar', 'sha256')