mysql之将表中的明文变为MD5

原来表中的密码为明文’123456’

mysql> select * from company_qq.current_user;
+----+-----------+-------+----------+----------+----------+-----------+---------+--------------------+---------+-----------+---------------+------------+--------------+-------------------+------------+----------------+-----------------+-------------+---------------+--------------+-------------+--------------+-----------+------------+-----------+
| ID | IP        | Port  | Name     | PassWord | isOnline | true_name | dept_id | highest_edu        | race_id | job_time  | political_lan | office_tel | mobile_phone | email             | qq_num     | native_country | native_province | native_city | native_county | native_other | now_country | now_province | now_city  | now_county | now_other |
+----+-----------+-------+----------+----------+----------+-----------+---------+--------------------+---------+-----------+---------------+------------+--------------+-------------------+------------+----------------+-----------------+-------------+---------------+--------------+-------------+--------------+-----------+------------+-----------+
|  1 | 127.0.0.1 | 11001 | kaikai   | 123456   |       12 |           |       1 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
|  2 | 127.0.0.1 | 11001 | kaikai1  | 123456   |       12 |           |       1 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
|  3 | 127.0.0.1 | 11001 | kaikai2  | 123456   |       12 |           |       0 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
|  4 | 127.0.0.1 | 11001 | kaikai3  | 123456   |       12 |           |       0 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
|  5 | 127.0.0.1 | 11001 | kaikai5  | 123456   |       12 |           |       0 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
|  6 | 127.0.0.1 | 11001 | kaikai6  | 123456   |       12 |           |       0 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
|  7 | 127.0.0.1 | 11001 | kaikai7  | 123456   |       12 |           |       0 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
|  8 | 127.0.0.1 | 11001 | kaikai8  | 123456   |       12 |           |       0 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
|  9 | 127.0.0.1 | 11001 | kaikai9  | 123456   |       12 |           |       0 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
| 10 | 127.0.0.1 | 11001 | kaikai10 | 123456   |       12 |           |       0 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
| 11 | 127.0.0.1 | 11001 | kaikai11 | 123456   |       12 |           |       0 |                    | 0       |           |             1 |            |              |                   |            |              0 | 0               | 0           | 0             |              |           0 | 0            | 0         | 0          |           |
| 12 | 127.0.0.1 | 11001 | kaikai12 | 123456   |       12 | 单凯      |       1 | 大学本科在读       | 汉      | 2016-7-13 |             0 | 110        | 18186482897  | 1431173103@qq.com | 1431173103 |             47 | 山东省          | 潍 坊市      | 都昌街道      | 乖常村       |          26 | 湖北省       | 武汉市    | 洪山区     | 地大      |
| 13 | 127.0.0.1 | 11001 | kaikai13 | 123456   |       12 | myEMP     |       1 | benke              | 汉      | 1997-1-1  |             1 | 1          | 1            | 1                 | 1          |              3 | 山东            | 菏 泽        | 诸城          | 金华         |           3 | 湖北         | 武汉      | 洪山区     | 地大      |
| 14 | 127.0.0.1 | 11001 | kaikai14 | 123456   |       12 | myEMP     |       1 | benke              | 汉      | 1997-1-1  |             1 | 1          | 1            | 1                 | 1          |              3 | 山东            | 菏 泽        | 诸城          | 金华         |           3 | 湖北         | 武汉      | 洪山区     | 地大      |
+----+-----------+-------+----------+----------+----------+-----------+---------+--------------------+---------+-----------+---------------+------------+--------------+-------------------+------------+----------------+-----------------+-------------+---------------+--------------+-------------+--------------+-----------+------------+-----------+
14 rows in set (0.00 sec)

更改

 update company_qq.current_user set password=md5(password);
Query OK, 14 rows affected (0.06 sec)
Rows matched: 14  Changed: 14  Warnings: 0

更改之后的结果