mysql 内置函数

MySQL [test]> select password(123);
+-------------------------------------------+
| password(123)                             |
+-------------------------------------------+
| *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+-------------------------------------------+
1 row in set (0.03 sec)

MySQL [test]> select md5("ac");
+----------------------------------+
| md5("ac")                        |
+----------------------------------+
| e2075474294983e013ee4dd2201c7a73 |
+----------------------------------+
1 row in set (0.03 sec)

MySQL [test]> select length(md5(123));
+------------------+
| length(md5(123)) |
+------------------+
|               32 |
+------------------+
1 row in set (0.03 sec)

原文地址:https://www.cnblogs.com/brookin/p/10176739.html