Check function parameter and return value : Function Returning « Procedure Function « SQL / MySQL





Check function parameter and return value

  
mysql>
mysql> delimiter $$
mysql>
mysql> CREATE FUNCTION myFunction(in_status CHAR(1))
    ->      RETURNS VARCHAR(20)
    -> BEGIN
    ->      IF in_status = 'O' THEN
    ->           RETURN('Overdue');
    ->      ELSEIF in_status = 'U' THEN
    ->           RETURN('Up to date');
    ->      ELSEIF in_status = 'N' THEN
    ->           RETURN('New');
    ->      END IF;
    -> END$$
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> delimiter ;
mysql>
mysql> select myFunction('O');
+-----------------+
| myFunction('O') |
+-----------------+
| Overdue         |
+-----------------+
1 row in set (0.00 sec)

mysql>
mysql> select myFunction('U');
+-----------------+
| myFunction('U') |
+-----------------+
| Up to date      |
+-----------------+
1 row in set (0.00 sec)

mysql>
mysql> select myFunction('N');
+-----------------+
| myFunction('N') |
+-----------------+
| New             |
+-----------------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql> drop function myFunction;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>

          
  










Related examples in the same category

1.Return value from a function
2.Return integer value from a function
3.Return NUMERIC(8,2) from a function
4.Using the returning value from a user-defined function in order by clause
5.Returning Decimal from the function
6.function returnes int