生成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)

原文地址:https://www.cnblogs.com/hzcya1995/p/13350755.html