mysql 触发器update

-- 创建表
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50),
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- 创建触发器
DELIMITER $$
CREATE TRIGGER after_user_update
AFTER UPDATE ON users
FOR EACH ROW
BEGIN
    INSERT INTO user_update_log (user_id, old_name, new_name, old_email, new_email, updated_at)
    VALUES (OLD.id, OLD.name, NEW.name, OLD.email, NEW.email, NOW());
END$$
DELIMITER ;

-- 创建日志表
CREATE TABLE user_update_log (
    log_id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    old_name VARCHAR(50),
    new_name VARCHAR(50),
    old_email VARCHAR(50),
    new_email VARCHAR(50),
    updated_at TIMESTAMP
);