意思就是创建函数
创建一个存储
create procedure function1() begin
select * from buy;
end$(这里的function1是存储名,没有参数,select * from buy;是sql语句,$是修改的结束符)
使用存储
call function1()$
call 存储名()$
删除存储
drop procedure function1$
drop procedure 存储名$
查看存储
show procedure status$
创建有参的存储
create procedure function2(sum tinyint) begin
if sum=4 then
select * from class where id>sum;
else
select * from class where id<=sum;
end if;
end$