SELECT b.target_host AS 'host',
a.target_ip AS 'Target',
a.monitor_type AS 'Type Monitor',
Concat (a.metric_name, "", a.metric_value) AS "metric name value"
FROM pm_sis_raw_metrics AS a
INNER JOIN pm_sis_hs_metrics AS b
ON a.id = b.id
WHERE metric_value > 80
AND ( metric_name = "utilization"
OR metric_name = "physical memory used %"
OR metric_name = "disk/file system/[c]/percent full"
OR metric_name = "% packets good" )
错误1052:where子句中的“metric\u name”列不明确
1条答案
按热度按时间yftpprvb1#
必须使用列名指定表别名,如where cause中的.metric\u name。