mysql实施面试题：存储过程从1加到100

CREATE DEFINER = CURRENT_USER PROCEDURE `存储过程名称`()
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;

END;