Name
SHA()
Synopsis
SHA(string
)
This function returns the Secure Hash Algorithm (SHA) 160-bit checksum for the given string. The result is a string composed of 40 hexadecimal digits. NULL is returned if the given string is NULL. This function is synonymous with SHA1(). Here is an example:
SELECT SHA('test'); +------------------------------------------+ | SHA('test') | +------------------------------------------+ | a94a8fe5ccb19ba61c4c0873d391e987982fbbd3 | +------------------------------------------+
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.