how to create procedure in mysql for selecting record?

how to write开发者_运维技巧 procedure in mysql to select record from particular table with IN and OUT parameter?

delimiter //

create procedure sample (in id int, out MyCount int)
begin
    select count(*) into MyCount 
        from YourTable 
        where YourKey = id;
end//