Mysql中的加密函数

一 加密函数PASSWORD(str)

mysql> select password('newpwd');
+-------------------------------------------+
| password('newpwd')                        |
+-------------------------------------------+
| *1FA85AA204CC12B39B20E8F1E839D11B3F9E6AA4 |
+-------------------------------------------+
1 row in set, 1 warning (0.03 sec)

二 加密函数MD5(str)

mysql> select md5('mypwd');
+----------------------------------+
| md5('mypwd')                     |
+----------------------------------+
| 318bcb4be908d0da6448a0db76908d78 |
+----------------------------------+
1 row in set (0.01 sec)

三 加密函数ENCODE(str,pswd_str)

mysql> select encode('secret','cry'),length(encode('secret','cry'));
+------------------------+--------------------------------+
| encode('secret','cry') | length(encode('secret','cry')) |
+------------------------+--------------------------------+
| úhû                     |                              6 |
+------------------------+--------------------------------+
1 row in set, 2 warnings (0.01 sec)

四 DECODE(str,pswd_str)

mysql> select decode(encode('secret','cry'),'cry');
+--------------------------------------+
| decode(encode('secret','cry'),'cry') |
+--------------------------------------+
| secret                               |
+--------------------------------------+
1 row in set, 2 warnings (0.00 sec)