MySQL - Create stored procedures

 DELIMITER $$

CREATE PROCEDURE doWhileInsertCity2(

    -- input parameters

)

BEGIN

    

-- do something ...

END$$

DELIMITER ;