Mega Code Archive

 

Categories / MySQL Tutorial / Encryption Compression Functions

 

SHA1(str), SHA(str) calculates an SHA-1 160-bit checksum for the string

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