MYSQL學(xué)習(xí)
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 存儲過程輸入輸出參數(shù)示例》要點(diǎn)：
本文介紹了MYSQL教程mysql 存儲過程輸入輸出參數(shù)示例，希望對您有用。如果有疑問，可以聯(lián)系我們。
MYSQL學(xué)習(xí)
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;
轉(zhuǎn)載請注明本頁網(wǎng)址：
http://www.snjht.com/jiaocheng/6423.html
