mysql存储过程输入输出参数示例_MySQL
来源：动视网
责编：小采
时间：2020-11-09 19:37:51
mysql存储过程输入输出参数示例_MySQL
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;
导读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 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
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;
