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//
精彩评论