mysql判断字段是否存在 函数

-- 查询方式
SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'your_database_name'
AND TABLE_NAME = 'your_table_name'
AND COLUMN_NAME = 'your_column_name';

-- 存储过程方式
DELIMITER //

CREATE PROCEDURE CheckColumnExists(
    IN dbName VARCHAR(255),
    IN tableName VARCHAR(255),
    IN columnName VARCHAR(255),
    OUT exists INT
)
BEGIN
    SELECT COUNT(*)
    INTO exists
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_SCHEMA = dbName
    AND TABLE_NAME = tableName
    AND COLUMN_NAME = columnName;
END //

DELIMITER ;

-- 调用存储过程
CALL CheckColumnExists('your_database_name', 'your_table_name', 'your_column_name', @exists);
SELECT @exists;

GRANT SELECT ON information_schema.* TO 'your_user'@'localhost';

GRANT CREATE ROUTINE ON your_database_name.* TO 'your_user'@'localhost';