String

MD5

MySQL

Menghitung MD5 hash 128-bit dari string. Return 32 character hexadecimal string.

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

Syntax

SQL

MD5(str)

strVARCHARwajib

String yang akan di-hash

SQL

1 SELECT MD5('hello') AS hash;

MD5 hash dari 'hello'.

Hasil

hash: 5d41402abc4b2a76b9719d911017c592

SQL

1 SELECT file_name,
2        MD5(CONCAT(file_name, file_size)) AS checksum
3 FROM files;

Generate checksum untuk file.

Hasil

(checksums for files)

SQL

1 SELECT MD5(content) AS content_hash, COUNT(*) AS copies
2 FROM documents
3 GROUP BY MD5(content)
4 HAVING COUNT(*) > 1;

Menemukan duplikat berdasarkan konten.

Hasil

(duplicate content)

1	SELECT file_name,
2	MD5(CONCAT(file_name, file_size)) AS checksum
3	FROM files;

1	SELECT MD5(content) AS content_hash, COUNT(*) AS copies
2	FROM documents
3	GROUP BY MD5(content)
4	HAVING COUNT(*) > 1;