mysql 一次插入大量数据

-- 批量插入示例
INSERT INTO users (id, name, email) VALUES 
(1, 'Alice', 'alice@example.com'),
(2, 'Bob', 'bob@example.com'),
(3, 'Charlie', 'charlie@example.com');

-- 使用事务示例
START TRANSACTION;
INSERT INTO users (id, name, email) VALUES (1, 'Alice', 'alice@example.com');
INSERT INTO users (id, name, email) VALUES (2, 'Bob', 'bob@example.com');
INSERT INTO users (id, name, email) VALUES (3, 'Charlie', 'charlie@example.com');
COMMIT;

-- 使用预处理语句示例
PREPARE stmt FROM 'INSERT INTO users (id, name, email) VALUES (?, ?, ?)';
SET @id = 1;
SET @name = 'Alice';
SET @email = 'alice@example.com';
EXECUTE stmt USING @id, @name, @email;
DEALLOCATE PREPARE stmt;