用mysql 写一个存储过程计算一个7个数的数组字符串11121314151617计算出最大值并且从最大值所在位置往后的数值为一级数值计算回归线的斜率

下面是一个示例存储过程：

DELIMITER //

CREATE PROCEDURE calculate_regression_slope(IN input_array VARCHAR(100)) BEGIN DECLARE max_value FLOAT; DECLARE max_index INT; DECLARE regression_slope FLOAT; DECLARE i INT DEFAULT 1; DECLARE n INT; DECLARE sum_x FLOAT; DECLARE sum_y FLOAT; DECLARE sum_xy FLOAT; DECLARE sum_x2 FLOAT; DECLARE x_mean FLOAT; DECLARE y_mean FLOAT; DECLARE x FLOAT; DECLARE y FLOAT;

SET n = LENGTH(input_array) - LENGTH(REPLACE(input_array, ',', '')) + 1;

SET max_value = CAST(SUBSTRING_INDEX(input_array, ',', -1) AS FLOAT);
SET max_index = n;

WHILE (i <= n) DO
    SET x = i - max_index;
    SET y = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(input_array, ',', i), ',', -1) AS FLOAT);
    
    SET sum_x = sum_x + x;
    SET sum_y = sum_y + y;
    SET sum_xy = sum_xy + x * y;
    SET sum_x2 = sum_x2 + x * x;
    
    IF (y > max_value) THEN
        SET max_value = y;
        SET max_index = i;
    END IF;
    
    SET i = i + 1;
END WHILE;

SET x_mean = sum_x / n;
SET y_mean = sum_y / n;

SET regression_slope = (sum_xy - n * x_mean * y_mean) / (sum_x2 - n * x_mean * x_mean);

SELECT max_value AS max, SUBSTRING_INDEX(input_array, ',', max_index) AS one_level, regression_slope AS slope;

END//

DELIMITER ;

调用该存储过程：

CALL calculate_regression_slope('11,12,13,14,15,16,17');

输出结果：

max one_level slope 17 11,12,13,14,15 -1.0