Product Solutions Support
Try MemSQL

MD5

Hashes the given string or binary data using the message digest algorithm, version 5. MD5 has been strongly deprecated as a means of securely signing data, given the multiple weaknesses discovered in the algorithm. It is present in MemSQL mainly for backwards compatibility and for systems which require a “good enough” hashing function and can tolerate collisions. For a more secure hash function, see SHA2.

MD5(plaintext)

Arguments

Return Type

32 lower case hexadecimal digits corresponding to the 128-bit binary hash value.

Examples

memsql> select md5('ohai');
+----------------------------------+
| md5('ohai')                      |
+----------------------------------+
| 5a73678b7b674005056434a48054707d |
+----------------------------------+
Was this article useful?