mysql如何添加大数据

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

ALTER TABLE table_name DISABLE KEYS;
-- 执行插入操作
ALTER TABLE table_name ENABLE KEYS;

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

CREATE TABLE sales (
    id INT NOT NULL,
    amount DOUBLE NOT NULL,
    sale_date DATE NOT NULL
)
PARTITION BY RANGE (YEAR(sale_date)) (
    PARTITION p0 VALUES LESS THAN (2010),
    PARTITION p1 VALUES LESS THAN (2015),
    PARTITION p2 VALUES LESS THAN (2020),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

START TRANSACTION;
INSERT INTO table_name (column1, column2) VALUES (value1, value2);
INSERT INTO table_name (column1, column2) VALUES (value3, value4);
...
COMMIT;