mysql insert多条数据

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'), 
('Bob', 'bob@example.com'), 
('Charlie', 'charlie@example.com');

-- 使用INSERT IGNORE忽略主键冲突
INSERT IGNORE INTO users (name, email) VALUES 
('Alice', 'alice@example.com'), 
('Bob', 'bob@example.com'), 
('Alice', 'alice2@example.com');

-- 使用REPLACE INTO替换主键冲突的数据
REPLACE INTO users (id, name, email) VALUES 
(1, 'Alice', 'alice2@example.com');

-- 分批次插入数据
INSERT INTO users (name, email) VALUES 
('Alice', 'alice@example.com'), 
('Bob', 'bob@example.com');
INSERT INTO users (name, email) VALUES 
('Charlie', 'charlie@example.com'), 
('David', 'david@example.com');

-- 使用LOAD DATA INFILE从文件中导入数据
LOAD DATA INFILE '/path/to/data.txt' INTO TABLE users
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '
'
(name, email);