mysql 一次插入海量数据

-- 批量插入示例
INSERT INTO table_name (column1, column2, column3) VALUES
('value1', 'value2', 'value3'),
('value4', 'value5', 'value6'),
('value7', 'value8', 'value9');

-- 使用事务示例
START TRANSACTION;
INSERT INTO table_name (column1, column2, column3) VALUES ('value1', 'value2', 'value3');
INSERT INTO table_name (column1, column2, column3) VALUES ('value4', 'value5', 'value6');
COMMIT;

-- 预处理语句示例
PREPARE stmt FROM 'INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)';
SET @value1 = 'value1';
SET @value2 = 'value2';
SET @value3 = 'value3';
EXECUTE stmt USING @value1, @value2, @value3;
DEALLOCATE PREPARE stmt;