All pages
Powered by GitBook
1 of 1

Loading...

MD5

Calculate MD5 checksum. This function returns the MD5 hash of a string as a 32-character hexadecimal number.

Syntax

MD5(str)

Description

Calculates an MD5 128-bit checksum for the string.

The return value is a 32-hex digit string, and a nonbinary string in the connection , determined by the values of the and system variables.

NULL is returned if the argument was NULL.

Examples

This page is licensed: GPLv2, originally from

SELECT MD5('testing');
+----------------------------------+
| MD5('testing')                   |
+----------------------------------+
| ae2b1fca515949e5d54fb22b8ed95575 |
+----------------------------------+
character set and collation
character_set_connection
collation_connection
fill_help_tables.sql