MySQL Create Custom Function (1)

1. Create a test custom function (1)

CREATE definer= ' dbdh ' @ ' localhost ' FUNCTION ' test '. ' Sp_function_dbdh_three ' () RETURNS varchar (255) CHARSET UTF8
BEGIN
DECLARE l_new_str VARCHAR (255); --Defining variables
DECLARE L_NAYIBU_NUM1 INT;

SET l_nayibu_num1=101;

IF (l_nayibu_num1>100) Then
SET l_new_str= ' both '; --Assigned value
ELSE
SET l_new_str= ' one ';
END IF;
return (L_NEW_STR);--return value

END

2. Verify the results of the output:

Mysql> select Sp_function_dbdh_three ();
+---------------+
| Sp_function_dbdh_three () |
+---------------+
| both |
+---------------+
1 row in Set (0.00 sec)

MySQL Create Custom Function (1)