同步mysql表数据 触发器

DELIMITER $$

CREATE TRIGGER sync_data_after_insert
AFTER INSERT ON source_table
FOR EACH ROW
BEGIN
    INSERT INTO target_table (id, name, value)
    VALUES (NEW.id, NEW.name, NEW.value);
END$$

CREATE TRIGGER sync_data_after_update
AFTER UPDATE ON source_table
FOR EACH ROW
BEGIN
    UPDATE target_table
    SET name = NEW.name, value = NEW.value
    WHERE id = OLD.id;
END$$

CREATE TRIGGER sync_data_after_delete
AFTER DELETE ON source_table
FOR EACH ROW
BEGIN
    DELETE FROM target_table WHERE id = OLD.id;
END$$

DELIMITER ;

CREATE TABLE source_table (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    value INT
);

CREATE TABLE target_table (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    value INT
);