mysql存储过程 声明数组

DELIMITER //

CREATE PROCEDURE example_procedure()
BEGIN
    -- 创建临时表来模拟数组
    CREATE TEMPORARY TABLE temp_array (
        idx INT PRIMARY KEY AUTO_INCREMENT,
        value INT
    );

    -- 插入数据到临时表
    INSERT INTO temp_array (value) VALUES (1), (2), (3);

    -- 查询临时表中的数据
    SELECT * FROM temp_array;

    -- 删除临时表
    DROP TEMPORARY TABLE IF EXISTS temp_array;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE example_procedure()
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE array_value INT;
    DECLARE array_length INT DEFAULT 3;

    WHILE i <= array_length DO
        SET array_value = i * 10; -- 模拟数组元素的赋值
        SELECT array_value;
        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE example_procedure()
BEGIN
    DECLARE json_array JSON;

    -- 设置JSON数组
    SET json_array = JSON_ARRAY(1, 2, 3);

    -- 查询JSON数组中的数据
    SELECT JSON_EXTRACT(json_array, CONCAT('$[', i, ']')) AS value FROM (
        SELECT 0 AS i UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9
    ) AS numbers WHERE i < JSON_LENGTH(json_array);
END //

DELIMITER ;