mysql - SQL:包含 where 子句的计数语句的总和

Question

我有 3 个计数语句，我需要将它们合并并求和。

SELECT COUNT(status) 
FROM tableA 
WHERE env='test' 
AND deploy_date='2016-10-19' 
AND  platform='MA' 
AND server='B' 
AND status='5';

SELECT COUNT(status) 
FROM tableA 
WHERE env='test' 
AND deploy_date='2016-10-19'  
AND  platform='MA'  
AND server='B' 
AND status='3';

SELECT COUNT(status) 
FROM tableA 
WHERE env='test' 
AND deploy_date='2016-10-19' 
AND  platform='MA' 
AND server='B' 
AND status='1'; 

我试过了

SELECT (select count(status) 
FROM tableA 
WHERE env='test' 
AND deploy_date='2016-10-19' 
AND  platform='MA' 
AND server='B' and status='5'; ) + 
(SELECT COUNT(status) 
FROM tableA WHERE env='test' 
AND deploy_date='2016-10-19' 
AND  platform='MA' 
AND server='B' AND status='3';) + 
(SELECT COUNT(status) 
FROM tableA
WHERE env='test' 
AND deploy_date='2016-10-19' 
AND  platform='MA' 
AND server='B' AND status='1';)

但是出现语法错误。我错过了什么？有没有更好的方法在 MySQL 中完成此操作。提前致谢

Answer 1

这里有一种组合方式

SELECT count(1)
FROM   tableA
WHERE  env = 'test'
       AND deploy_date = '2016-10-19'
       AND platform = 'MA'
       AND server = 'B'
       AND status IN ( '5', '3', '1' );