加密命令:
MD5(字段名/字段值)
示例一:
SELECT
a.vin,
MD5(a.vin) vin_md5
FROM
(SELECT DISTINCT vin FROM t_vin) a;
示例二:
INSERT INTO `db_member` (NAME,sex,age,pwd) VALUES('zhangsan',1,100,MD5('123456'))
示例三:
-- 如果我们要对Upwd这一列数据进行加密,语法是:
update test set Upwd = md5(Upwd);
-- 如果单独对某个用户(如Tom)的密码加密:
update test set Upwd = md5(Upwd) where Uname = “Tom”;