一、mysql循环插入数据语句和子查询插入

  DROP PROCEDURE IF EXISTS test_insert;
  DELIMITER $
  CREATE PROCEDURE test_insert()
  BEGIN
      DECLARE i INT DEFAULT 1;
      WHILE i<=10000 DO
          INSERT INTO data(user_id) VALUES(i);
          SET i = i+1;
      END WHILE;
  END $
  CALL test_insert();

二、子查询循环插入查询示例 循环插入tableA表数据，param1来源是uuid去除-，param2自定义输入，param3为子查询tableB表的返回id值，每次只分页查询一条，页数按照循环的次数来决定

  DROP PROCEDURE IF EXISTS test_insert;
  DELIMITER $
  CREATE PROCEDURE test_insert()
  BEGIN
      DECLARE i INT DEFAULT 0;
      WHILE i<= 68 DO
          INSERT INTO tableA(param1,param2,param3) VALUES(replace(uuid(),'-',''),1,(SELECT id FROM tableB LIMIT i ,1));
          SET i = i+1;
      END WHILE;
  END $
  CALL test_insert();