Collections:
SHA2() - Calculating SHA-2 Hash
How to calculate a hash value of a byte string using the SHA2() function?
✍: FYIcenter.com
SHA2(str, len) is a MySQL built-in function that calculates a hash value of a given byte string using the SHA-2 (Secure Hash Algorithm 2) family of algorithms (SHA-224, SHA-256, SHA-384, and SHA-512). For example:
SELECT SHA2('abc', 256); SELECT SHA2('FYI', 256); -- +------------------------------------------------------------------+ -- | SHA2('FYI', 256) | -- +------------------------------------------------------------------+ -- | 3050d21d6aa694b99a7fc48eb57d390b64d64543e0ee9c78aadec620ad81fc73 | -- +------------------------------------------------------------------+ SELECT SHA2('FYIcenter.com', 256); -- +------------------------------------------------------------------+ -- | SHA2('FYIcenter.com', 256) | -- +------------------------------------------------------------------+ -- | 9b3b41aa6093ec4c463697ac4fa0e71c88528346c22bf173bda806e5ceb799cd | -- +------------------------------------------------------------------+ SELECT SHA2('FYIcenter.com', 384); -- +--------------------------------------------------------------------------------------------------+ -- | SHA2('FYIcenter.com', 384) | -- +--------------------------------------------------------------------------------------------------+ -- | 485ce34c0cfc9fb150d27ce56f38f656cb994f3ace97670b3937758816e8506761b3c73ef6bee2963a5296a2b877e4cf | -- +--------------------------------------------------------------------------------------------------+
Reference information of the SHA2() function:
SHA2(str, len): hash Calculates a hash value of a given byte string using the SHA-2 algorithm. Arguments, return value and availability: str: Required. The byte string to be processed. len: Required. The number of bits of the resulting hash. hash: Return value. The SHA1 hash value in hexadecimal digits Available since MySQL 4.1.
Related MySQL functions:
⇒ STATEMENT_DIGEST() - Statement Digest Hash
⇐ SHA1() - Calculating SHA-1 Hash
2023-12-14, 266🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...