mysql存储过程参数可选,在MySQL的存储过程中编写可选参数？

I would like to create a stored procedure which updates either all fields in a table or just a few of them according to parameters passed to it.

How do I create a stored procedure that accepts optional parameters?

解决方案

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 ;