MySQL: User-Define Function

Question

For the user-define function in MYSQL,

I passs in one parameter to udf (a int);

if a is NULL return 2.0; else return 3.0

`DELIMITER !
CREATE FUNCTION return val(a INTEGER) RETURNS NUMERIC(10,2)
BEGIN
  If (isNULL(a)) THEN return 2.0
  ELSE RETURN 3.0;
  END IF;
END!

DELIMITER ;`

Is this the right way to do it?

Yes, apparently, there isn't a function call isNull, so how can I tell about whether the a is a NULL — wrek
– wrek, Commented Nov 2, 2016 at 0:14
So do I change it to if (SELECT a IS NULL) THEN RETURN 2.0 — wrek
– wrek, Commented Nov 2, 2016 at 0:31

bogzy · Accepted Answer · 2016-11-02 02:48:24Z

1

You may also try this one using CASE statement:

CASE WHEN a IS NULL or a = ''
     then '2.0'
     else '3.0'
END

answered Nov 2, 2016 at 2:48

bogzy

1263 bronze badges

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

Collectives™ on Stack Overflow

MySQL: User-Define Function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related