Question

mysql如何通过sql查询将列值全部md5加密

Answer 1

一般安全一点的做法是 1给user 表加一个字段PMD5;
2 UPDATE USER SET pmd5=md5(password) //用MD5值来更新;
3 删除原来的password字段;
4 pmd5 字段改名为password字段;
完成.

Answer 2

select md5(***) as ***, md5(***) as *** from ~table