Showing entries 1 to 1
Displaying posts with tag: declare (reset)
Jun
19
2014
Use of DECLARE and SET in MySQL stored program
Posted by Rookie Dev on Thu 19 Jun 2014 16:25 UTC
Tags:

DELIMITER $$                    -- Change the delimiter

DROP PROCEDURE IF EXISTS demo$$ -- Remove if previously exists
CREATE PROCEDURE demo()         -- Create Stored Procedure
BEGIN                           -- Start of definition
    DECLARE my_int INT;         -- Declare variables
    DECLARE my_big_int BIGINT;
    DECLARE my_text TEXT;

    DECLARE my_name VARCHAR(30) -- Declare variables with 
        DEFAULT 'Rookie Dev';   -- default value set

    SET my_int = 20;            -- Set variables to values …

[Read more]
Showing entries 1 to 1