mysql 获取下一条记录

DELIMITER //

CREATE PROCEDURE GetNextRecord(IN last_id INT)
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE cur_id INT;
    DECLARE cur_data TEXT;

    -- 假设有一个表 `my_table`，包含 `id` 和 `data` 两个字段
    DECLARE cur CURSOR FOR SELECT id, data FROM my_table WHERE id > last_id ORDER BY id ASC;
    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;
        -- 处理 cur_id 和 cur_data
        SELECT cur_id, cur_data;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

-- 假设有一个表 `my_table`，包含 `id` 和 `data` 两个字段
SELECT id, data FROM my_table ORDER BY id ASC LIMIT 1 OFFSET last_id;

-- 假设当前最后一条记录的 id 是 10
SET @last_id = 10;

SELECT id, data FROM my_table ORDER BY id ASC LIMIT 1 OFFSET @last_id;