不能实现,用CASE WHEN代替 相似 的有ITERATE, and LEAVE ITERATE labelITERATE can appear only within LOOP, REPEAT, and WHILE statements. ITERATE means “do the loop again.” Example: 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
相似 的有ITERATE, and LEAVE
ITERATE labelITERATE can appear only within LOOP, REPEAT, and WHILE statements. ITERATE means “do the loop again.” Example: 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
你只能通过IF THEN来实现。