带有游标的Mysql触发器，用于从一个表中提取所有列并插入到另一个表中

DELIMITER $$

CREATE TRIGGER after_source_table_insert
AFTER INSERT
ON source_table FOR EACH ROW
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE cur_id INT;
    DECLARE cur_data TEXT;

    -- 创建游标
    DECLARE cur CURSOR FOR SELECT id, data FROM source_table;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    -- 打开游标
    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO cur_id, cur_data;
        IF done THEN
            LEAVE read_loop;
        END IF;

        -- 插入数据到目标表
        INSERT INTO target_table (id, data) VALUES (cur_id, cur_data);
    END LOOP;

    -- 关闭游标
    CLOSE cur;
END$$

DELIMITER ;