mysql如何查看修改记录吗

[mysqld]
log-bin=mysql-bin

mysqlbinlog /path/to/mysql-bin.000001

mysqlbinlog /path/to/mysql-bin.000001 | grep -i users

CREATE TABLE users_audit (
    id INT AUTO_INCREMENT PRIMARY KEY,
    action VARCHAR(10),
    table_name VARCHAR(50),
    record_id INT,
    action_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

DELIMITER $$

CREATE TRIGGER after_users_insert
AFTER INSERT ON users
FOR EACH ROW
BEGIN
    INSERT INTO users_audit (action, table_name, record_id)
    VALUES ('INSERT', 'users', NEW.id);
END$$

CREATE TRIGGER after_users_update
AFTER UPDATE ON users
FOR EACH ROW
BEGIN
    INSERT INTO users_audit (action, table_name, record_id)
    VALUES ('UPDATE', 'users', NEW.id);
END$$

CREATE TRIGGER after_users_delete
AFTER DELETE ON users
FOR EACH ROW
BEGIN
    INSERT INTO users_audit (action, table_name, record_id)
    VALUES ('DELETE', 'users', OLD.id);
END$$

DELIMITER ;

pt-query-digest /path/to/mysql-bin.000001