mysql 存储过程新增表

DELIMITER //

CREATE PROCEDURE CreateNewTable(IN tableName VARCHAR(255), IN columns TEXT)
BEGIN
    DECLARE sqlQuery VARCHAR(1000);
    SET sqlQuery = CONCAT('CREATE TABLE ', tableName, ' (', columns, ')');
    PREPARE stmt FROM sqlQuery;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END //

DELIMITER ;

CALL CreateNewTable('new_table', 'id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), age INT');

DELIMITER //

CREATE PROCEDURE CreateNewTable(IN tableName VARCHAR(255), IN columns TEXT)
BEGIN
    DECLARE sqlQuery VARCHAR(1000);
    IF NOT EXISTS (SELECT * FROM information_schema.TABLES WHERE TABLE_NAME = tableName) THEN
        SET sqlQuery = CONCAT('CREATE TABLE ', tableName, ' (', columns, ')');
        PREPARE stmt FROM sqlQuery;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    ELSE
        SELECT CONCAT('Table ', tableName, ' already exists.') AS message;
    END IF;
END //

DELIMITER ;