String

MD5

DuckDB

Menghitung MD5 hash dari string. Mengembalikan 32-character hexadecimal string. Berguna untuk checksums dan data fingerprinting.

Tipe hasil: VARCHAR (32 hex characters)Diperbarui: 6 Jan 2026

Syntax

SQL

MD5(string)

stringVARCHARwajib

String yang akan di-hash

SQL

1 SELECT
2   email,
3   MD5(email) as email_hash
4 FROM users
5 LIMIT 3;

Membuat hash dari email untuk anonymization.

Hasil

email	email_hash
budi@gmail.com	5d41402abc4b2a76b9719d911017c592
ani@yahoo.com	098f6bcd4621d373cade4e832627b4f6

SQL

1 SELECT
2   id,
3   MD5(CONCAT(name, email, phone)) as record_fingerprint
4 FROM customers;

Membuat fingerprint unik untuk setiap record untuk change detection.

Hasil

id	record_fingerprint
1	a1b2c3d4e5f6789012345678abcdef01
2	b2c3d4e5f6789012345678abcdef0123

SQL

1 SELECT
2   MD5(content) as content_hash,
3   COUNT(*) as duplicate_count
4 FROM documents
5 GROUP BY MD5(content)
6 HAVING COUNT(*) > 1;

Menemukan dokumen duplikat berdasarkan content hash.

Hasil

content_hash	duplicate_count
f1d2d2f924e986ac86fdf7b36c94bcdf	3
e99a18c428cb38d5f260853678922e03	2

1	SELECT
2	id,
3	MD5(CONCAT(name, email, phone)) as record_fingerprint
4	FROM customers;