mysql与存储过程

//1.创建存储过程
create procedure p(num int)//参数可有可无
begin
select * from user where id>num;
end$//使用delimiter $ 修改

2.调用存储过程

call p(2)$

3.体会控制语句

create procedure p1(num int,method char(1))
begin
 if method='h' then
   select*from user where id>num;
else
  select*from user where id<num;
end if;
end$
 

 体会while控制语句

create procedure p3(num smallint)
begin
  //声明2个变量
  declare i int;
  declare s int;
  set i=1;
 set s=0;
 while num>=i do
  set s=s+i;
  set i=i+1;
end while;
select s;
end$

 

总结:存储过程与函数的区别

1.函数是function 存储过程是procedure

2.存储过程没有返回值