1、表中定義了每項指標對應的函式
2、在存盤程序需要統計每項指標的資料：
DECLARE v_label_code VARCHAR(50);
DECLARE v_label_value VARCHAR(125);
DECLARE v_calc_function VARCHAR(125);
DECLARE v_func_param VARCHAR(50);
DECLARE over INT DEFAULT FALSE;
DECLARE feature_cursor CURSOR FOR SELECT label_code, calc_function, func_param FROM feature_define WHERE status = 1 and Id = 1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET over = TRUE;
OPEN feature_cursor;
loop_1 :LOOP
FETCH feature_cursor INTO v_label_code, v_calc_function, v_func_param;
IF over THEN
LEAVE loop_1;
END
IF;
SELECT CONCAT(v_calc_function, '(', v_func_param, ')') INTO v_label_value;
SELECT v_label_code;
SELECT v_label_value;
END
LOOP
loop_1;
CLOSE feature_cursor;
3、實際呼叫結果回傳是字串，而非函式的呼叫
請問如何解決？
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/183240.html
標籤：MySQL