drop table if exists fordel;
create table fordel (a int);
insert into fordel values (1);
insert into fordel values (5);

DELIMITER //;

DROP procedure if exists fetch_n_select //

CREATE procedure fetch_n_select()
BEGIN
  DECLARE a INT;
  DECLARE done INT DEFAULT 0;
  DECLARE cur1 CURSOR FOR SELECT * FROM fordel WHERE a > 1;
  DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;

  SELECT * FROM fordel WHERE a > 1;
END //

DELIMITER ;//

SELECT * FROM fordel WHERE a > 1 ;

CALL fetch_n_select();

drop table fordel;