首页 / 数据库 / MySQL / 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;