MySQL SHA1() function

SHA1() function

MySQL sha1() function calculates an SHA-1 160-bit checksum for a string.

The function returns a value as a binary string of 40 hex digits. If the string supplied as the argument is NULL, the function returns NULL.

Syntax:

SHA1(str)

Argument:

Syntax Diagram:

MySQL Version: 5.6

Example:

Code:

SELECT SHA1('w3resource');

Explanation:

The above MySQL statement returns SHA1 checksum of w3resouce string. The return value is d228359c41174cede6b3c401eb8d11746a4ad1eb.

Sample Output:

mysql> SELECT SHA1('w3resource');
+------------------------------------------+
| SHA1('w3resource')                       |
+------------------------------------------+
| d228359c41174cede6b3c401eb8d11746a4ad1eb | 
+------------------------------------------+
1 row in set (0.00 sec)

Previous: PASSWORD()
Next: UNCOMPRESS()