String

SHA2

MySQL

Menghitung SHA-2 hash dengan panjang tertentu. Support SHA-224, SHA-256, SHA-384, SHA-512.

Tipe hasil: VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

SHA2(str, hash_length)

strVARCHARwajib

String yang akan di-hash

hash_lengthINTwajib

Panjang hash: 224, 256, 384, 512, atau 0 (=256)

SQL

1 SELECT SHA2('hello', 256) AS hash;

SHA-256 hash dari 'hello'.

Hasil

hash: 2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824

SQL

1 SELECT SHA2(CONCAT(password, salt), 512) AS password_hash
2 FROM users;

Secure password hashing dengan salt.

Hasil

(secure hashes)

SQL

1 SELECT id, SHA2(content, 256) AS fingerprint
2 FROM articles;

Generate fingerprint untuk content.

Hasil

(content fingerprints)

SHA2

Snowflake

SHA256

BigQuery

1	SELECT SHA2(CONCAT(password, salt), 512) AS password_hash
2	FROM users;

1	SELECT id, SHA2(content, 256) AS fingerprint
2	FROM articles;