生成md5密码 

mysql> select md5(concat((select md5("admin123") from test limit 1),'`xx')) from test;
+------------------------------------------------------------------+
| md5(concat((select md5("admin123") from test limit 1),'`1qazx')) |
+------------------------------------------------------------------+
| 18575bf7ee87ae4277cbcec02b9a2645                                 |
| 18575bf7ee87ae4277cbcec02b9a2645                                 |
| 18575bf7ee87ae4277cbcec02b9a2645                                 |
+------------------------------------------------------------------+
3 rows in set (0.00 sec)

posted @ 2016-05-27 12:07  czcb  阅读(262)  评论(0)  编辑  收藏  举报