--存储过程:解决某一特征功能的sql语句集
--存储过程的创建:
--1)无入参无返回:
drop PROCEDURE if exists get_student;
CREATE PROCEDURE get_student()
BEGIN
select * from student;
END
--调用存储过程:
CALL get_student()
--2)有入参无返回:
drop procedure if exists get_sid;
create procedure get_sid(in sid int)
begin
select * from student where s_id=sid;
end
--调用:
call get_sid(001)
--3)无入参有返回:
drop procedure if exists get_maxid;
create procedure get_maxid(out maxid int)
begin
select max(s_id) into maxid from student;
end
--调用:
call get_maxid(@maxid);
select @maxid
--4)有入参有返回:
drop procedure if exists get_sage;
create procedure get_sage(inout s_age int)
begin
set s_age=s_age+2;
end
--调用:
set @age=2;
call get_sage(@age);
select @age
select * from student;
select * from teacher;