Mysql创建存储过程示例_设置变量方法_

CREATE TABLE zzm(  
 id INT PRIMARY KEY AUTO_INCREMENT,  
 NAME VARCHAR(10)  
 );  
 
DELIMITER $ 
 CREATE PROCEDURE p3(IN nameid INT, OUT person_name VARCHAR(10))  
 BEGIN  
 SELECT * FROM test.zzm;  
SELECT zzm.name INTO person_name FROM test.zzm WHERE zzm.id = nameid;  
 END  
 $  

上面是创建存储过程的示例

示例2

DELIMITER $   
 CREATE PROCEDURE p6()
 BEGIN    
 
 END    
 $   

调用方法

CALL p6()

示例3

 SET @nameid =1;
 CALL p7(@nameid);

示例4 查询变量

 SELECT @nameid;