Mega Code Archive

 

Categories / MySQL / Procedure Function

 

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;