mysql 写循环语句

DELIMITER //

CREATE PROCEDURE BatchInsert(IN maxRows INT)
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i <= maxRows DO
        INSERT INTO your_table (column1, column2) VALUES (i, CONCAT('Value', i));
        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE BatchInsertOptimized(IN maxRows INT)
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE batchCount INT DEFAULT 100;
    DECLARE valuesString VARCHAR(10000);
    DECLARE valueString VARCHAR(255);

    WHILE i <= maxRows DO
        SET valueString = CONCAT('(', i, ', ', '''Value', i, ''''), ');
        SET valuesString = CONCAT(valuesString, valueString);

        IF i % batchCount = 0 THEN
            SET valuesString = SUBSTRING(valuesString, 1, LENGTH(valuesString) - 1);
            INSERT INTO your_table (column1, column2) VALUES valuesString;
            SET valuesString = '';
        END IF;

        SET i = i + 1;
    END WHILE;

    IF valuesString != '' THEN
        SET valuesString = SUBSTRING(valuesString, 1, LENGTH(valuesString) - 1);
        INSERT INTO your_table (column1, column2) VALUES valuesString;
    END IF;
END //

DELIMITER ;