mysql插入百万数据

START TRANSACTION;

INSERT INTO table_name (column1, column2, column3)
VALUES
    (value1, value2, value3),
    (value4, value5, value6),
    ...
    (valueN-2, valueN-1, valueN);

COMMIT;

LOAD DATA INFILE 'data.txt'
INTO TABLE table_name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

SET GLOBAL innodb_fast_shutdown = 0;
SET GLOBAL innodb_buffer_pool_size = 2G;
SET GLOBAL key_buffer_size = 512M;
SET GLOBAL innodb_log_file_size = 256M;
SET GLOBAL sql_log_bin = OFF;

DELIMITER //

CREATE PROCEDURE InsertData()
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i <= 1000000 DO
        INSERT INTO table_name (column1, column2, column3) VALUES (i, i+1, i+2);
        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

CALL InsertData();