如何在mysql中创建循环行值

DELIMITER $$
CREATE PROCEDURE create_loop_rows()
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i <= 10 DO
        -- 在此处执行你需要的操作，例如插入数据到表中
        INSERT INTO your_table (column1) VALUES (i);
        SET i = i + 1;
    END WHILE;
END $$
DELIMITER ;

CALL create_loop_rows();

CREATE TEMPORARY TABLE temp_table (value INT);

WITH RECURSIVE loop_values AS (
    SELECT 1 AS value
    UNION ALL
    SELECT value + 1 FROM loop_values WHERE value < 10
)
INSERT INTO temp_table (value)
SELECT value FROM loop_values;

SELECT * FROM temp_table;