MySQL 建立自訂函數(1)

標籤：

1. 建立測試自訂函數(1)

CREATE DEFINER=`dbdh`@`localhost` FUNCTION `test`.`sp_function_dbdh_three`() RETURNS varchar(255) CHARSET utf8
BEGIN
    DECLARE l_NEW_STR VARCHAR(255);  -- 定義變數
    DECLARE l_NAYIBU_NUM1   INT;
 
    SET l_NAYIBU_NUM1=101;

    IF (l_NAYIBU_NUM1>100) THEN
       SET l_NEW_STR=‘TWO‘; --賦值
    ELSE
 SET l_NEW_STR=‘ONE‘;
    END IF;
     RETURN(l_NEW_STR);--傳回值
 
   END

2. 驗證輸出結果:

 

mysql> select sp_function_dbdh_three();
+---------------+
| sp_function_dbdh_three() |
+---------------+
| TWO           |
+---------------+
1 row in set (0.00 sec)

 

MySQL 建立自訂函數(1)