mysql加密函数

最新推荐文章于 2024-03-01 13:10:36 发布

weixin_30552635

最新推荐文章于 2024-03-01 13:10:36 发布

阅读量47

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/dengyg200891/p/6013029.html

版权

md5
password()


//案例
mysql> select md5('xiaodeng');
+----------------------------------+
| md5('xiaodeng')                  |
+----------------------------------+
| accd5818a8547b13180044139260c80d |
+----------------------------------+
1 row in set (0.09 sec)

mysql> select password('xiaodeng');
+-------------------------------------------+
| password('xiaodeng')                      |
+-------------------------------------------+
| *37F20A3D69B0CE32DE36C6D57BFB0408A63F80DE |
+-------------------------------------------+
1 row in set, 1 warning (0.05 sec)