delimiter $    //这个是把结束符号变为$

create procedure p1(N int)

begin

declare total int default 0;

declare num int default 0;

while num<=N do

total := total + num;

num := num + 1;

end while;

select concat(total) as 总和为;

end$

结果：