SET @col_exists = (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'scheme_benefit_deduct_settings' AND COLUMN_NAME = 'commodity'); SET @sql = ...