Optional Parameters
are not yet supported on MySQL. I’m suggesting that you pass null
value in your parameter and inside your stored procedure has an IF
statement.
DELIMITER $$
CREATE PROCEDURE procName
(IN param VARCHAR(25))
BEGIN
IF param IS NULL THEN
-- statements ;
ELSE commands
-- statements ;
END IF;
END$$
DELIMITER ;