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;