- 明文加密
INSERT INTO testmd5 VALUES(1,'张三','123456'),(2,'李四','123456'),(3,'王五','123456')
- 单个加密
UPDATE testmd5 SET pwd=MD5(pwd) WHERE id = 1
- 全部加密
UPDATE testmd5 SET pwd=MD5(pwd)
- 插入时加密
INSERT INTO testmd5 VALUES(4,'小明',MD5('123456'))
- 比对,将传进来的值,进行MD5加密,然后进行比对加密后的值
SELECT * FROM testmd5 WHERE `name`='小明' AND pwd=MD5('123456')