DELIMITER $$

DROP PROCEDURE IF EXISTS `new_routine` $$
CREATE DEFINER=`root`@`%` PROCEDURE `new_routine`()
BEGIN
    -- This is the first line
    SELECT NOW() AS an_example;
    -- This is the last line
END $$

DELIMITER ;