mysql测试md5加密

1. 创建表

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 

2.向表中插入数据

 INSERT INTO `testmd5` VALUES(1,"zhangsan","123456"),(2,"list","123456"),(3,'wangwu','123456')

3.密码md5加密

 UPDATE testmd5 SET pwd = MD5(pwd) WHERE id =1

4.加密全部密码

UPDATE testmd5 SET pwd = MD5(pwd)

5.插入数据时加密

 INSERT INTO `testmd5` VALUES(4,'xiaoming',MD5('123456'))