mysql数据库md5加密

-- 创建一个包含密码字段的表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    password VARCHAR(32) NOT NULL
);

-- 插入一条数据，并对密码进行MD5加密
INSERT INTO users (username, password) VALUES ('user1', MD5('password123'));

-- 查询数据并验证密码
SELECT * FROM users WHERE username = 'user1' AND password = MD5('password123');

ALTER TABLE users MODIFY COLUMN password VARCHAR(32) NOT NULL;

-- 使用SHA-256加密
INSERT INTO users (username, password) VALUES ('user2', SHA2('password456', 256));

-- 使用盐值加密
INSERT INTO users (username, password) VALUES ('user3', MD5(CONCAT('salt123', 'password789')));