mysql 游标多值

DECLARE cur CURSOR FOR SELECT * FROM your_table;
OPEN cur;

FETCH NEXT FROM cur INTO @var1, @var2;
WHILE @@FETCH_STATUS = 0
BEGIN
    -- 处理数据
    FETCH NEXT FROM cur INTO @var1, @var2;
END

CLOSE cur;
DEALLOCATE CURSOR cur;

DELIMITER //

CREATE PROCEDURE process_data()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE var1 INT;
    DECLARE var2 VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT id, name FROM your_table;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH NEXT FROM cur INTO var1, var2;
        IF done THEN
            LEAVE read_loop;
        END IF;
        -- 处理数据
        SELECT var1, var2;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

CALL process_data();