优化1中的许多SQL请求(Optimize many SQL request in 1)

优化1中的许多SQL请求(Optimize many SQL request in 1)

我有一个小问题，我有3个SQL请求，我想知道是否可以在1个请求中优化它们。

我的3个sql请求：

SELECT FAI, COUNT( FAI ) AS deferred_count FROM `email_errors` WHERE STATUS =1 GROUP BY FAI ------------------------------------------- SELECT FAI, COUNT( FAI ) AS sent_count FROM `email_errors` WHERE STATUS =0 GROUP BY FAI ------------------------------------------- SELECT FAI, COUNT( FAI ) AS Bounced_count FROM `email_errors` WHERE STATUS =2 GROUP BY FAI

所以，如果可能的话，我尝试获得一个具有4列结果的输出表FAI|deferred_count|sent_count|bounced_count

我不知道是否可以根据请求通过'FAI'加入？

I have a little question, i have thse 3 SQL requests, and i want to know if it's possible to optimize them in 1 request.

My 3 sql request:

SELECT FAI, COUNT( FAI ) AS deferred_count FROM `email_errors` WHERE STATUS =1 GROUP BY FAI ------------------------------------------- SELECT FAI, COUNT( FAI ) AS sent_count FROM `email_errors` WHERE STATUS =0 GROUP BY FAI ------------------------------------------- SELECT FAI, COUNT( FAI ) AS Bounced_count FROM `email_errors` WHERE STATUS =2 GROUP BY FAI

So if it's possible, i try to get one output table with 4 column result FAI|deferred_count|sent_count|bounced_count

i don't know if it's possible to make a join by 'FAI' on the request?

最满意答案

SELECT FAI, sum( status = 0 ) AS send_count, sum( status = 1 ) AS deferred_count, sum( status = 2 ) AS Bounced_count FROM `email_errors` GROUP BY FAI SELECT FAI, sum( status = 0 ) AS send_count, sum( status = 1 ) AS deferred_count, sum( status = 2 ) AS Bounced_count FROM `email_errors` GROUP BY FAI