search

Home >Database >Mysql Tutorial >mysql 存储过程输入输出参数示例_MySQL

mysql 存储过程输入输出参数示例_MySQL

WBOY
WBOYOriginal
2016-06-01 13:05:15991browse

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;

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL错误ERROR 2002 (HY000): Can't connect to local MySQL server through socket_MySQLNext article：mysql delete limit 使用方法详解_MySQL

Related articles

See more