如何在历史记录中存储所有记录更改，以便在MySQL中轻松跟踪

CREATE TABLE history_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    record_id INT,
    field1 VARCHAR(255),
    field2 VARCHAR(255),
    ...
    timestamp DATETIME,
    action VARCHAR(10)
);

CREATE TRIGGER history_trigger
AFTER INSERT ON original_table
FOR EACH ROW
BEGIN
    INSERT INTO history_table (record_id, field1, field2, ..., timestamp, action)
    VALUES (NEW.id, NEW.field1, NEW.field2, ..., NOW(), 'INSERT');
END;

CREATE TRIGGER history_trigger
AFTER UPDATE ON original_table
FOR EACH ROW
BEGIN
    INSERT INTO history_table (record_id, field1, field2, ..., timestamp, action)
    VALUES (NEW.id, NEW.field1, NEW.field2, ..., NOW(), 'UPDATE');
END;

CREATE TRIGGER history_trigger
AFTER DELETE ON original_table
FOR EACH ROW
BEGIN
    INSERT INTO history_table (record_id, field1, field2, ..., timestamp, action)
    VALUES (OLD.id, OLD.field1, OLD.field2, ..., NOW(), 'DELETE');
END;