search

Home  >  Article  >  Database  >  mysql 存储过程输入输出参数示例

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

WBOY
WBOYOriginal
2016-06-07 16:28:51961browse

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;

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(停止服务、卸载相关程序、删除注册表Next article：优化MySQL数据库中的查询语句详解

Related articles

See more