mysql存储过程批量添加数据

DELIMITER //

CREATE PROCEDURE BatchInsertData(IN tableName VARCHAR(255), IN data JSON)
BEGIN
    DECLARE i INT DEFAULT 0;
    DECLARE rowCount INT;
    DECLARE columns VARCHAR(255);
    DECLARE values VARCHAR(255);
    DECLARE sqlQuery VARCHAR(1000);

    SET rowCount = JSON_LENGTH(data);
    SET columns = JSON_UNQUOTE(JSON_EXTRACT(data, CONCAT('$[', i, '].columns')));
    SET values = JSON_UNQUOTE(JSON_EXTRACT(data, CONCAT('$[', i, '].values')));

    SET sqlQuery = CONCAT('INSERT INTO ', tableName, ' (', columns, ') VALUES (', values, ')');

    WHILE i < rowCount DO
        PREPARE stmt FROM sqlQuery;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

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

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

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