Name
SHA( )
Synopsis
SHA(string
)
This
function returns the Secure Hash Algorithm (SHA) 160-bit checksum for
the given string. The results are a string composed of 40 hexadecimal
digits. NULL is returned if the given string is NULL. This function
is synonymous with SHA1( )
.
SELECT SHA('test'); +------------------------------------------+ | SHA('test') | +------------------------------------------+ | a94a8fe5ccb19ba61c4c0873d391e987982fbbd3 | +------------------------------------------+
Get MySQL in a Nutshell 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.