mysql 存储过程创建

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');