【MySql】6 MD5() 函数的使用

1、全部加密

update js_user set pwd = MD5(pwd);

+----------+----------------------------------+
| name     | pwd                              |
+----------+----------------------------------+
| 刘翔     | e10adc3949ba59abbe56e057f20f883e |
| 姚明     | 7676fbe0b671cd5fd59b31f7dd5a7c78 |
| 马龙     | 23bc53d8b0d2130e51c40289a2260285 |
| 刘国梁   | 15db49655bee88caabbfabbc3ea81bf1 |
| 欧阳国一 | 91efcc2c9e2494c92196711293dbe200 |
| 杨国忠   | 114a4e1bc5344c4d86fd1ff75f3dc09b |
+----------+----------------------------------+
6 rows in set

2、插入数据

INSERT into js_user VALUES(8,'马云',MD5('mayunjack123'),'男','杭州','1368136127312',5)

+----------+----------------------------------+
| name     | pwd                              |
+----------+----------------------------------+
| 刘翔     | e10adc3949ba59abbe56e057f20f883e |
| 姚明     | 7676fbe0b671cd5fd59b31f7dd5a7c78 |
| 马龙     | 23bc53d8b0d2130e51c40289a2260285 |
| 刘国梁   | 15db49655bee88caabbfabbc3ea81bf1 |
| 欧阳国一 | 91efcc2c9e2494c92196711293dbe200 |
| 杨国忠   | 114a4e1bc5344c4d86fd1ff75f3dc09b |
| 马云     | 2bdc6375565bb899a771e85a48fc127a |
+----------+----------------------------------+
7 rows in set

3、校验

-- 思路
-- 匹配加密后的 哈希值就好。

SELECT  *  from js_user WHERE MD5('mayunjack123')=pwd;

+----+------+----------------------------------+-----+---------+---------------+---------+
| id | name | pwd                              | sex | address | telephone     | gradeid |
+----+------+----------------------------------+-----+---------+---------------+---------+
|  8 | 马云 | 2bdc6375565bb899a771e85a48fc127a | 男  | 杭州    | 1368136127312 |       5 |
+----+------+----------------------------------+-----+---------+---------------+---------+
1 row in set