mysql 存储过程从1加到100
DELIMITER $
CREATE PROCEDURE `存储过程从1加到100`() BEGIN declare a int(10) default 1; declare b int(10) default 0; L:loop if a > 100 then leave L; ELSE set b = b + a ; set a = a + 1 ; END IF; end loop; select b as '存储过程从1加到100';
END $
DELIMITER $
CREATE PROCEDURE `存储过程从1加到100`() BEGIN declare a int(10) default 1; declare b int(10) default 0; L:loop if a > 100 then leave L; ELSE set b = b + a ; set a = a + 1 ; END IF; end loop; select b as '存储过程从1加到100';
END $