是否可以在Merge语句中实现循环，并在每6000行中提交

MERGE INTO target_table
USING source_table
ON merge_condition
WHEN MATCHED THEN
    UPDATE SET column1 = value1, column2 = value2
WHEN NOT MATCHED THEN
    INSERT (column1, column2) VALUES (value1, value2);

DELIMITER //

CREATE PROCEDURE merge_with_loop()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE source_value INT;
    DECLARE cur CURSOR FOR SELECT value FROM source_table;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO source_value;
        IF done THEN
            LEAVE read_loop;
        END IF;

        -- 在此处编写需要执行的操作，例如插入或更新操作
        -- INSERT INTO target_table (column1) VALUES (source_value);
        -- UPDATE target_table SET column1 = source_value WHERE condition;

        -- 每6000行提交一次
        IF (cur%6000 = 0) THEN
            COMMIT;
        END IF;
    END LOOP;

    CLOSE cur;
    COMMIT;
END //

DELIMITER ;