mysql 怎么跳出循环

参考以下

CREATE PROCEDURE nested_blocks5(  )

 outer_block: BEGIN

        DECLARE l_status int

        SET l_status=1

        inner_block: BEGIN

                IF (l_status=1) THEN

                        LEAVE inner_block

                END IF

        SELECT 'This statement will never be executed'

        END inner_block

        SELECT 'End of program'

END outer_block

DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET loopend = 0

声明loopend变量。

open IdCursor

loop_label:LOOP

fetch IdCursor into loopend

IF loopend = 0 THEN

leave loop_label

else...

---