gistfile1.txt

DELIMITER $$
CREATE PROCEDURE myproc()
BEGIN
    DECLARE i int DEFAULT 1993;
    WHILE i <= 2014 DO
        INSERT INTO year (year) VALUES (i);
        SET i = i + 1;
    END WHILE;
/* whole procedure ends with the custom delimiter */
END$$

/* Finally, reset the delimiter to the default ; */
DELIMITER ;

CALL myproc();