mysql存储过程批量插入

DELIMITER //

CREATE PROCEDURE BatchInsert(IN tableName VARCHAR(255), IN data JSON)
BEGIN
    DECLARE i INT DEFAULT 0;
    DECLARE rowCount INT;
    DECLARE columnNames VARCHAR(255);
    DECLARE placeholders VARCHAR(1000);
    DECLARE values JSON;

    SET rowCount = JSON_LENGTH(data);
    SET columnNames = JSON_UNQUOTE(JSON_EXTRACT(data, '$[0].*'));
    SET placeholders = REPEAT('?, ', rowCount - 1) || '?';

    SET @sql = CONCAT('INSERT INTO ', tableName, ' (', columnNames, ') VALUES (', placeholders, ')');

    PREPARE stmt FROM @sql;
    LOOP
        SET i = i + 1;
        SET values = JSON_EXTRACT(data, CONCAT('$[', i - 1, ']'));
        EXECUTE stmt USING JSON_UNQUOTE(JSON_EXTRACT(values, '$.*'));
        IF i = rowCount THEN
            LEAVE LOOP;
        END IF;
    END LOOP;

    DEALLOCATE PREPARE stmt;
END //

DELIMITER ;

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

[
    {"name": "Alice", "email": "alice@example.com"},
    {"name": "Bob", "email": "bob@example.com"}
]

CALL BatchInsert('users', '[
    {"name": "Alice", "email": "alice@example.com"},
    {"name": "Bob", "email": "bob@example.com"}
]');