Mega Code Archive
Three inout parameters
<![CDATA[
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
]]>