LEAVE(退出)

语法结构

LEAVE label

说明描述

该语法用来退出循环或者结构。经常用在BEGIN ... END或者LOOP, REPEAT, WHILE中。在存储过程,Triggers and Events,LEAVE can refer to the outmost BEGIN ... END construct。 Stored Functions, RETURN 可以用来替换leave语法。

注意:leave 不能用来退出DECLARE HANDLER

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.