mysql存储过程输入输出参数示例
来源：动视网
责编：小采
时间：2020-11-09 13:26:06
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; drop PROCEDURE if exists
导读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
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;
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; drop PROCEDURE if exists
