代码改变世界

mysql 内置函数

2018-12-25 22:02  brookin  阅读(180)  评论(0)  编辑  收藏  举报 
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)