mysql一次插入大量数据

-- 单条插入
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');

-- 批量插入（使用存储过程）
DELIMITER $$
CREATE PROCEDURE BatchInsertUsers(IN names TEXT, IN emails TEXT)
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE name VARCHAR(255);
    DECLARE email VARCHAR(255);
    WHILE i <= LENGTH(names) DO
        SET name = SUBSTRING_INDEX(SUBSTRING_INDEX(names, ',', i), ',', -1);
        SET email = SUBSTRING_INDEX(SUBSTRING_INDEX(emails, ',', i), ',', -1);
        INSERT INTO users (name, email) VALUES (name, email);
        SET i = i + 1;
    END WHILE;
END$$
DELIMITER ;

CALL BatchInsertUsers('Alice,Bob,Charlie', 'alice@example.com,bob@example.com,charlie@example.com');