如何统计记录在SQL中被修改的次数

CREATE TRIGGER count_updates
AFTER UPDATE ON your_table
FOR EACH ROW
BEGIN
    UPDATE your_table
    SET modification_count = modification_count + 1
    WHERE id = NEW.id;
END;

CREATE TABLE your_table (
    id INT,
    data VARCHAR(100),
    modification_count INT DEFAULT 0
);

CREATE PROCEDURE update_record(IN record_id INT, IN new_data VARCHAR(100))
BEGIN
    UPDATE your_table
    SET data = new_data,
        modification_count = modification_count + 1
    WHERE id = record_id;
END;