数据库级别的MD5加密

数据库级别的MD5加密

--测试MD5加密
CREATE TABLE `testmd5`(
`id` INT(4) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(20) NOT NULL,
`pwd` VARCHAR(50) NOT NULL,
PRIMARY KEY(`id`)
)ENGINE =INNODB DEFAULT CHARSET=utf8

--明文密码
INSERT INTO `testmd5`(`name`,`pwd`) VALUES
('zhangsan','123456'),('lishi','123456')
--加密
UPDATE `testmd5` SET pwd = MD5(pwd) WHERE id = 1
UPDATE `testmd5` SET pwd = MD5(pwd)--加密全部密码
--插入的时候加密
INSERT INTO `testmd5`(`name`,`pwd`) VALUES('wangwu',MD5('123456'))
--校验：将用户传递进来的密码进行MD5加密，然后对比加密后的值
SELECT * FROM `testmd5` WHERE `name`='zhangsan' AND pwd = MD5('123456')