MariaDB: SP:FOR

FOR i IN 1..3
DO
  INSERT INTO t1 VALUES (i);
END FOR;//


FOR i IN REVERSE 12..4
    DO
    INSERT INTO t1 VALUES (i);
END FOR;//


CREATE OR REPLACE PROCEDURE p1(pa INT) AS 
  CURSOR cur(va INT) IS
    SELECT a, b FROM t1 WHERE a=va;
BEGIN
  FOR rec IN cur(pa)
  LOOP
    SELECT rec.a, rec.b;
  END LOOP;
END;//