Three inout parameters : Parameters « Procedure Function « SQL / MySQL

1. SQL / MySQL
2. Procedure Function
3. Parameters

Three inout parameters

       

DELIMITER $$

CREATE PROCEDURE FIBONNACI
   (INOUT NUMBER1 INTEGER,
    INOUT NUMBER2 INTEGER,
    INOUT NUMBER3 INTEGER)
BEGIN
   SET NUMBER3 = NUMBER1 + NUMBER2;
   IF NUMBER3 > 10000 THEN
      SET NUMBER3 = NUMBER3 - 10000;
   END IF;
   SET NUMBER1 = NUMBER2;
   SET NUMBER2 = NUMBER3;
END$$

DELIMITER ;


SET @A=16, @B=27
;
SELECT @C
;
SELECT @C
;
SELECT @C

   
    
    
    
    
    
    
  

Related examples in the same category