给你个例子参考:
CREATE DEFINER=`admin`@`%` PROCEDURE `USP_Abc`(v_att INT
)
SWL_return:
BEGIN
SELECT ....
IF v_at>=v_att THEN
SELECT -520 AS 'Version';
LEAVE SWL_return;
END IF;
IF EXISTS(SELECT * FROM ttt WHERE ..) THEN
SELECT ...;
LEAVE SWL_return;
END IF;
END$$
DELIMITER ;
CREATE PROCEDURE p14 ()
BEGIN
DECLARE v INT;
SET v = 0;
WHILE v < 5 DO
INSERT INTO t VALUES (v);
SET v = v + 1;
END WHILE;
END; //