delimiter //

create procedure select_all()

begin

select * from t_user;

end

//

call select_all();

 

#删除存储过程

drop procedure select_all;

#创建存储过程

delimiter //

create procedure select_all(user_name varchar(30))

begin

select * from t_user where t_user.user_name = user_name;

end

//

delimiter ;

#调用存储过程

call select_all('test');