Assign value to an out parameter : Parameters « Procedure Function « SQL / MySQL

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

Assign value to an out parameter

       



CREATE TABLE PLAYERS(
         PLAYERNO       INTEGER      NOT NULL,
         NAME           CHAR(15)     NOT NULL,
         INITIALS       CHAR(3)      NOT NULL,
         BIRTH_DATE     DATE                 ,
         SEX            CHAR(1)      NOT NULL,
         JOINED         SMALLINT     NOT NULL,
         STREET         VARCHAR(30)  NOT NULL,
         HOUSENO        CHAR(4)              ,
         POSTCODE       CHAR(6)              ,
         TOWN           VARCHAR(30)  NOT NULL,
         PHONENO        CHAR(13)             ,
         LEAGUENO       CHAR(4)              ,
         PRIMARY KEY    (PLAYERNO)           );
         
         
DELIMITER $$


CREATE PROCEDURE TEST(OUT NUMBER1 INTEGER)
BEGIN
   DECLARE NUMBER2 INTEGER
      DEFAULT (SELECT COUNT(*) FROM EmployeeS);
   SET NUMBER1 = NUMBER2;
END$$


DELIMITER ;

drop table Players;

drop  PROCEDURE TEST;

   
    
    
    
    
    
    
  

Related examples in the same category