MySQL创建存储过程

create procedure proc_2( @classNo varchar(50) )
as
select 学号,姓名,性别,出生年月
from student
where 班级=@classNo

执行存储过程

exec proc_2 @classNo = '20140207'