mysql insert多行数据

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...),
       (value1, value2, value3, ...),
       ...

INSERT INTO table_name (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM another_table
WHERE condition;

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

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

INSERT INTO users (name, email)
SELECT name, email FROM temp_users WHERE active = 1;

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

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO users (name, email)
VALUES ('Alice', 'alice@example.com')
ON DUPLICATE KEY UPDATE name = VALUES(name), email = VALUES(email);

-- 分批插入数据
INSERT INTO users (name, email)
VALUES ('Alice', 'alice@example.com'),
       ('Bob', 'bob@example.com'),
       ...
UNION ALL
SELECT * FROM (SELECT 'Charlie', 'charlie@example.com' UNION ALL SELECT 'David', 'david@example.com') AS tmp
LIMIT 1000;