DELIMITER $$
CREATE
PROCEDURE `myloop`()
BEGIN
DECLARE counter INT DEFAULT 0;
simple_loop: LOOP
SET counter=counter+10;
select counter;
IF counter=50 THEN
LEAVE simple_loop;
END IF;
END LOOP simple_loop;
END$$
DELIMITER ;
CREATE
PROCEDURE `myloop`()
BEGIN
DECLARE counter INT DEFAULT 0;
simple_loop: LOOP
SET counter=counter+10;
select counter;
IF counter=50 THEN
LEAVE simple_loop;
END IF;
END LOOP simple_loop;
END$$
DELIMITER ;
No comments:
Post a Comment