要写存储过程去循环了

Mysql 循环插入10000条数据（案列）_mysql insert10000次-CSDN博客

--改成你要循环的次数，其它的就自己拼就行了

DELIMITER $$

CREATE PROCEDURE LoopInsert()

BEGIN

    DECLARE i INT DEFAULT 1;

    WHILE i <= 10000 DO

        INSERT INTO example_table (data) VALUES (CONCAT('Row ', i));

        SET i = i + 1;

    END WHILE;

END$$

DELIMITER ;

多次循环的   26*100000次循环你改成你要的数字吧。。

DELIMITER //

CREATE PROCEDURE nested_loops_example()

BEGIN

  DECLARE outer_counter INT DEFAULT 1;

  DECLARE inner_counter INT DEFAULT 1;

  WHILE outer_counter <= 5 DO

    WHILE inner_counter <= 5 DO

      SELECT CONCAT('Outer loop iteration: ', outer_counter, ', Inner loop iteration: ', inner_counter) AS iteration;

      SET inner_counter = inner_counter + 1;

    END WHILE;

    SET outer_counter = outer_counter + 1;

    SET inner_counter = 1; -- Reset inner counter for next outer loop

  END WHILE;

END //

DELIMITER ;

CALL nested_loops_example();

是这个玩意吗

WITH numbers AS (

  SELECT 0 AS num

  UNION ALL

  SELECT num + 1 FROM numbers WHERE num < 9999

),

letters AS (

  SELECT 65 AS let

  UNION ALL

  SELECT let + 1 FROM letters WHERE let < 90

)

-- SELECT right(concat('0000',num),4) numstr FROM numbers OPTION (MAXRECURSION 10000)

SELECT char(let) let,numstr,right(numstr,2) numstr2

FROM letters s

left join (SELECT right(concat('0000',num),4) numstr FROM numbers )  b on 1=1

OPTION (MAXRECURSION 10000) -- 设置最大递归次数为10000(默认100)