Cursor Examples.txt

DELIMITER $$ CREATE PROCEDURE cursor_test() BEGIN DECLARE venrollmentSemesterId int(20); DECLARE vstudentId int(20); DECLARE cursor1 CURSOR FOR select enrollmentSemesterId,studentId from vmin_date_registration; OPEN cursor1; read_loop: LOOP FETCH cursor1 INTO venrollmentSemesterId,vstudentId; IF done THEN LEAVE read_loop; END IF; BEGIN update studentcharges set semesterId=venrollmentSemesterId where studentId=vstudentId; END; END LOOP; CLOSE cursor1; END$$ ----------CALL cursor_test(); ERROR 1054 (42S22): Unknown column 'done' in 'field list'