md5sum
Calculates the 128-bit checksum of multiple strings. The checksum is represented by a 32-character hexadecimal string.
If only one string is passed in, the result is the same as that of md5.
Compared to md5(), md5sum() accepts more parameters and therefore, is more efficient in calculating the checksum of multiple files.
Syntax
md5sum(expr,...);
Parameters
expr
: the string to calculate. It must be of the VARCHAR type.
Return value
Returns a checksum of the VARCHAR type.
Examples
mysql> select md5sum("starrocks");
+----------------------------------+
| md5sum('starrocks') |
+----------------------------------+
| f75523a916caf65f1ad487a9f8017f75 |
+----------------------------------+
1 row in set (0.01 sec)
mysql> select md5sum("starrocks","star");
+----------------------------------+
| md5sum('starrocks', 'star') |
+----------------------------------+
| 7af4bfe35b8df2786ad133c57cb2aed8 |
+----------------------------------+
1 row in set (0.01 sec)
mysql> select md5sum(null);
+----------------------------------+
| md5sum(NULL) |
+----------------------------------+
| d41d8cd98f00b204e9800998ecf8427e |
+----------------------------------+
1 row in set (0.01 sec)