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