mysql 删除列的存储过程

DELIMITER //

CREATE PROCEDURE DeleteColumn(
    IN tableName VARCHAR(255),
    IN columnName VARCHAR(255)
)
BEGIN
    DECLARE columnExists INT;
    
    -- 检查列是否存在
    SELECT COUNT(*) INTO columnExists
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = tableName AND COLUMN_NAME = columnName;
    
    IF columnExists > 0 THEN
        -- 删除列
        SET @sql = CONCAT('ALTER TABLE ', tableName, ' DROP COLUMN ', columnName);
        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
        
        SELECT CONCAT('Column ', columnName, ' deleted from table ', tableName) AS message;
    ELSE
        SELECT CONCAT('Column ', columnName, ' does not exist in table ', tableName) AS message;
    END IF;
END //

DELIMITER ;

CALL DeleteColumn('my_table', 'my_column');