MySQL Stored Procedure Cursor 的標準程式模板

DECLARE v_exit INT DEFAULT FALSE;

DECLARE cur_table CURSOR FOR
SELECT  field1, field2 FROM table;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_exit = TRUE;


OPEN cur_table;

my_fetch: LOOP
FETCH cur_table
INTO v_field1, v_field2;
IF v_exit THEN
LEAVE my_fetch;
END IF;

<process code here...>


END LOOP my_fetch;

CLOSE cur_table;