MD5
MD5主要增强算法复杂度和不可逆性
MD5不可逆,具体的值MD5是一样的
测试用例:
CREATE TABLE testmd5(
id int(4) not null,
`name` varchar(20) not null,
pwd varchar(50) not null,
PRIMARY KEY(id)
)ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO testmd5
VALUES(1,'张三','123456'),(2,'法外狂徒张三','123456');
-- 加密
UPDATE testmd5
SET pwd = MD5(pwd);
-- 添加的时候加密
INSERT INTO testmd5
VALUES(3,'张五',md5('123456')),(4,'法外狂徒张五',md5('123456'));
SELECT *
FROM testmd5
-- 如何校验
select *
from testmd5
where `name` = '张三' and pwd = MD5('123456')