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