DELIMITER // -- Or another non-reserved character
DROP PROCEDURE IF EXISTS sp_PopulateFizzBuzz//
CREATE PROCEDURE sp_PopulateFizzBuzz
(
IN p_MaxNumber INT, -- for example 100
IN p_Fizz INT,
IN p_Buzz INT,
IN p_Woof INT,
IN p_Ping INT,
IN p_Plop INT
)
BEGIN
SET v_MaxNumber = p_MaxNumber;
SET v_Fizz = p_Fizz;
SET v_Buzz = p_Buzz;
SET v_Woof = p_Woof;
SET v_Ping = p_Ping;
SET v_Plop = p_Plop;
/* bunch of code here that works fine */
-- end procedure sp_PopulateFizzBuzz