开发者

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//
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜