Writing additional parameters in stored procedures in MySQL?

Question

I would like to create a stored procedure that updates either all the fields in the table, or several of them in accordance with the parameters passed to it.

How to create a stored procedure that accepts optional parameters?

Answer 1

Optional Parameters are not yet supported in MySQL. I suggest you pass a null value in your parameter and inside your stored procedure has an IF .

 DELIMITER $$ CREATE PROCEDURE procName (IN param VARCHAR(25)) BEGIN IF param IS NULL THEN -- statements ; ELSE commands -- statements ; END IF; END$$ DELIMITER ; 

Answer 2

A special case is when the cant 'parameter is NULL, i.e. is the key. I use the trick for this case: I set the parameter to -1:

 CREATE PROCEDURE procCreate (IN id_cosa INT(11)) BEGIN IF id_cosa != -1 THEN ~~(your code here)~~ END IF END