To create a 160-bit encrypted value based on a specified string, you can use the SHA() or SHA1() functions : SHA « Function « SQL / MySQL

1. SQL / MySQL
2. Function
3. SHA

To create a 160-bit encrypted value based on a specified string, you can use the SHA() or SHA1() functions

    
mysql>
mysql> SELECT SHA('MyPassword');
+------------------------------------------+
| SHA('MyPassword')                        |
+------------------------------------------+
| daa1f31819ed4928fd00e986e6bda6dab6b177dc |
+------------------------------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
    
  

Related examples in the same category