mysql枚举统计_mysql – 计算枚举值？

您可以像这样运行三个查询：

SELECT COUNT(*)

FROM daily_individual_tracking

WHERE sales = 'YES'

AND daily_individual_tracking_date BETWEEN '2010-01-01' AND '2010-03-31'

或者,如果你想要,你可以像这样一次获得所有三个：

SELECT (

SELECT COUNT(*)

FROM daily_individual_tracking

WHERE sales = 'YES'

AND daily_individual_tracking_date BETWEEN '2010-01-01' AND '2010-03-31'

) AS sales_count, (

SELECT COUNT(*)

FROM daily_individual_tracking

WHERE repairs = 'YES'

AND daily_individual_tracking_date BETWEEN '2010-01-01' AND '2010-03-31'

) AS repairs_count, (

SELECT COUNT(*)

FROM daily_individual_tracking

WHERE shipping = 'YES'

AND daily_individual_tracking_date BETWEEN '2010-01-01' AND '2010-03-31'

) AS shipping_count

另一种方法是使用SUM而不是COUNT.您也可以尝试这一点,看看它如何影响性能：

SELECT

SUM(sales = 'YES') AS sales_count,

SUM(repairs = 'YES') AS repairs_count,

SUM(shipping = 'YES') AS shipping_count

FROM daily_individual_tracking

WHERE daily_individual_tracking_date BETWEEN '2010-01-01' AND '2010-03-31'