Adding parameters with NULL default value for MySQL stored procedure

Question

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

possible duplicate of Is it possible to have a default parameter for a mysql stored procedure? — Pang
– Pang, Commented Aug 21, 2014 at 3:22

Community · Accepted Answer · 2017-05-23 10:24:09Z

2

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.

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Dec 30, 2012 at 13:37

losthorse

1,5701 gold badge13 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bonCodigo · Accepted Answer · 2013-01-05 10:47:52Z

0

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
;

edited Jan 5, 2013 at 10:47

answered Dec 30, 2012 at 13:38

bonCodigo

14.4k1 gold badge52 silver badges93 bronze badges

Collectives™ on Stack Overflow

Adding parameters with NULL default value for MySQL stored procedure

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related