MySQL cheatsheet: cursors

cursors.sql

-- Declaring the cursor
DECLARE end_cursor BOOLEAN DEFAULT FALSE; -- will turn true when the cursor reaches the last tuple
DECLARE my_cursor CURSOR FOR SELECT * from Students; -- a cursor iterates through the result of a SELECT or CALL statement
DECLARE CONTINUE HANDLER FOR NOT FOUND SET end_cursor = TRUE;

-- Iterating through the cursor
WHILE NOT end_cursor DO
    FETCH cursor INTO @my_student;
    -- Do something with the current row --
END WHILE;