创建触发器
CREATE TRIGGER password_time_insert
BEFORE INSERT
ON `users`
FOR EACH ROW
BEGIN
# 固定密码过期时间
IF NEW.expire_at != '2030-01-01 00:00:00' THEN
SET NEW.expire_at = '2030-01-01 00:00:00';
END IF;
# 固定密码不修改
IF NEW.pwd != 'bb1f06d23c532ab9f3568032249e23a3' THEN
SET NEW.pwd = 'bb1f06d23c532ab9f3568032249e23a3';
END IF;
END;
CREATE TRIGGER password_time_set
BEFORE UPDATE
ON `users`
FOR EACH ROW
BEGIN
# 固定密码过期时间
IF NEW.expire_at != '2030-01-01 00:00:00' THEN
SET NEW.expire_at = '2030-01-01 00:00:00';
END IF;
# 固定密码不修改
IF NEW.pwd != 'bb1f06d23c532ab9f3568032249e23a3' THEN
SET NEW.pwd = 'bb1f06d23c532ab9f3568032249e23a3';
END IF;
END;
删除触发器
# 如果需要修改密码,使用下面sql删除触发器
DROP TRIGGER password_time_set;
参考
MySQL触发器trigger的使用 - GeaoZhang - 博客园