mysql增加多条记录

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');

INSERT INTO users (name, email) VALUES 
('Bob', 'bob@example.com'),
('Charlie', 'charlie@example.com'),
('David', 'david@example.com');

-- 正确的多条插入示例
INSERT INTO users (name, email) VALUES 
('Eve', 'eve@example.com'),
('Frank', 'frank@example.com');

START TRANSACTION;
INSERT INTO users (name, email) VALUES 
('Grace', 'grace@example.com'),
('Henry', 'henry@example.com');
COMMIT;

-- 分批次插入示例
DO 1000 TIMES (
    INSERT INTO users (name, email) VALUES 
    ('Ivy', 'ivy@example.com'),
    ('Jack', 'jack@example.com')
);