例如
DELIMITER //
CREATE PROCEDURE XX()
BEGIN
DECLARE i VARCHAR(10);
SET i=6;IF i>5 THEN
SELECT 'aaa' AS message ;
-- 我想程序执行到这个地方就终止执行后面的语句.直接退出SP .. 就像在java中的break一样...
END IF;IF i>4 THEN
SELECT 'bbb' AS message ;
END IF;IF i>3 THEN
SELECT 'ccc' AS message ;
END IF;
END//
DELIMITER;
求大哥明示~~~~~~
DELIMITER //
CREATE PROCEDURE XX()
BEGIN
DECLARE i VARCHAR(10);
SET i=6;IF i>5 THEN
SELECT 'aaa' AS message ;
-- 我想程序执行到这个地方就终止执行后面的语句.直接退出SP .. 就像在java中的break一样...
END IF;IF i>4 THEN
SELECT 'bbb' AS message ;
END IF;IF i>3 THEN
SELECT 'ccc' AS message ;
END IF;
END//
DELIMITER;
求大哥明示~~~~~~
CREATE PROCEDURE doiterate(p1 INT)
BEGIN
label1: LOOP
SET p1 = p1 + 1;
IF p1 < 10 THEN ITERATE label1; END IF;
LEAVE label1;
END LOOP label1;
SET @x = p1;
END
我想要的是退出整个SP这个label 要咋写呢?
CREATE PROCEDURE XX()
L_END: BEGINDECLARE i VARCHAR(10);
SET i=6;IF i>5 THEN
SELECT 'aaa' AS message ;
leave L_END;
END IF;IF i>4 THEN
SELECT 'bbb' AS message ;
END IF;IF i>3 THEN
SELECT 'ccc' AS message ;
END IF;
END;
END LOOP label1;//
DELIMITER;
CREATE PROCEDURE XX()
L_END:
BEGIN
DECLARE i VARCHAR(10);
SET i=6;IF i>5 THEN
SELECT 'aaa' AS message ;
LEAVE L_END;
END IF;IF i>4 THEN
SELECT 'bbb' AS message ;
END IF;IF i>3 THEN
SELECT 'ccc' AS message ;
END IF;END L_END//