dropPROCEDUREifexistsmy_procedure;createPROCEDUREmy_procedure(inmy_idint,outmy_namechar)BEGINselectlist_nameintomy_namef
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;