CODEWITHSUNDEEP
mysqlstored-procedures
Raed Alsaleh
Raed Alsaleh

Reputation: 1621

Adding parameters with NULL default value for MySQL stored procedure

How can I add parameters with NULL default value for MySQL stored procedure?

Upvotes: 2

Views: 27468

Answers (2)

bonCodigo
bonCodigo

Reputation: 14361

Any query with variable and 'case`:-

BEGIN 
    DECLARE @NullValue:=Null;  
    SELECT 
    CASE WHEN Sum(myField) Is Null 
    THEN @NullValue ELSE Sum(myField)
    END AS Total 
    FROM table_name; 
END
;

Upvotes: 0

losthorse
losthorse

Reputation: 1570

According to this answer MySQL does not support true 'default parameters' in functions or stored procedures.

This answer on the same page provides a solution that may work for you.

Upvotes: 2

Related Questions