SHA2(str, hash_length)

MySQL 8.4 🇮🇩 Bahasa Indonesia

SHA2(str, panjang_hash)

Syntax

MYSQL

SELECT SHA2('abc', 224);
'23097d223405d8228642a477bda255b32aadbce4bda0b3f7e36c9da7'

Contoh

Example

Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and SHA-512). The first argument is the plaintext string to be hashed. The second argument indicates the desired bit length of the result, which must have a value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If either argument is NULL or the hash length is not one of the permitted values, the return value is NULL. Otherwise, the function result is a hash value containing the desired number of bits. See the notes at the beginning of this section about storing hash values efficiently.

MYSQL

SELECT SHA2('abc', 224);
'23097d223405d8228642a477bda255b32aadbce4bda0b3f7e36c9da7'