当前位置:首页 > PHP教程 > PHP总结归纳

mysql存储过程输入输出参数示例

drop procedure if exists my_procedure; create procedure my_procedure(in my_id int,out my_name char) begin select list_name into my_name from aa_list where list_id=my_id; end; call my_procedure(24,@a); select @a;

drop procedure if exists my_procedure; create procedure my_procedure(in my_id int,out my_name char) begin select list_name into my_name from aa_list where list_id=my_id; end; call my_procedure(24,@a); select @a;.syntaxhighlighter{padding-top:20px;padding-bottom:20px;}

【说明】本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:)!