String

SHA1

MySQL

Menghitung SHA-1 hash 160-bit dari string. Return 40 character hexadecimal string.

Tipe hasil: VARCHAR(40)Diperbarui: 7 Jan 2026

Syntax

SQL

SHA1(str)

strVARCHARwajib

String yang akan di-hash

SQL

1 SELECT SHA1('hello') AS hash;

SHA1 hash dari 'hello'.

Hasil

hash: aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d

SQL

1 SELECT SHA1(CONCAT(user_id, NOW(), RAND())) AS token
2 FROM users;

Generate unique token.

Hasil

(unique tokens)

SQL

1 SELECT SHA1(CONCAT_WS('|', title, content, modified_at)) AS version_hash
2 FROM documents;

Hash untuk version tracking.

Hasil

(version hashes)

SHA1

Snowflake

SHA1

BigQuery

1	SELECT SHA1(CONCAT(user_id, NOW(), RAND())) AS token
2	FROM users;

1	SELECT SHA1(CONCAT_WS('\|', title, content, modified_at)) AS version_hash
2	FROM documents;