mysql批量插入返回id

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

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

SELECT LAST_INSERT_ID();

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

DELIMITER //

CREATE PROCEDURE BatchInsertUsers(IN names VARCHAR(255), IN emails VARCHAR(255))
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE name VARCHAR(255);
    DECLARE email VARCHAR(255);
    DECLARE result INT;

    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 result = LAST_INSERT_ID();

        -- 记录ID或进行其他处理
        SELECT result;

        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;