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 存储过程输入输出参数示例》要点:
本文介绍了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;
转载请注明本页网址:
http://www.vephp.com/jiaocheng/6423.html