mysql 返回空数据集_如果数据集为空,MySQL将返回默认值

你怎么添加一个UNION？

( SELECT coalesce(value, "NA") as value

FROM mytable FORCE INDEX (chrs) FORCE INDEX (sites)

WHERE chrom = 1 AND site = 120

)

UNION ALL

( SELECT 'NA' as value

FROM mytable

WHERE NOT EXISTS

( SELECT coalesce(value, "NA") as value

FROM mytable FORCE INDEX (chrs) FORCE INDEX (sites)

WHERE chrom = 1 AND site = 120

)

)

或者如果你想做一次合并,这样你就可以更容易地更改返回的部分,你可以这样选择它.

SELECT COALESCE(value, "NA") as value

FROM

(

( SELECT value

FROM mytable FORCE INDEX (chrs) FORCE INDEX (sites)

WHERE chrom = 1 AND site = 120

)

UNION ALL

( SELECT NULL as value

FROM mytable

WHERE NOT EXISTS

( SELECT value as value

FROM mytable FORCE INDEX (chrs) FORCE INDEX (sites)

WHERE chrom = 1 AND site = 120

)

)

) t