第九天

软件工程日报

学习时间：30分钟
代码量：40
知识点：
创建用户并授权：
CREATE USER 'dev_user'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE ON dbname.* TO 'dev_user'@'localhost';
-- 撤销权限
REVOKE INSERT ON dbname.* FROM 'dev_user'@'localhost';
创建触发器自动记录日志：
DELIMITER $$
CREATE TRIGGER before_user_update
BEFORE UPDATE ON users
FOR EACH ROW
BEGIN
INSERT INTO user_audit (user_id, old_email, new_email, change_time)
VALUES (OLD.id, OLD.email, NEW.email, NOW());
END $$
DELIMITER ;