mysql 存储过程

delimiter $

create PROCEDURE selectStudent(in passw VARCHAR(20),in bname VARCHAR(20))
BEGIN
    declare result int DEFAULT 0; #声明并初始化
    select count(*) into result from  student where password=passw and password=passw;
    select if(result>0,'hava data','no data');

end $

 

call selectStudent('hello','world')$

 

delimiter $

create PROCEDURE selectpbyn(in passw VARCHAR(20),out bname VARCHAR(20))
BEGIN
    select name into bname from student where password=passw;

end $
 

 

调用 call selectpbyn('world',@bbname)$;

select @name$;;

测试使用