在PHP中如何精打细算每月以下数据中的每个用户
SELECT * FROM sales_info WHERE assigned_dse_name IN ('ANBHAZHAGAN .') AND invoice_date BETWEEN '2016-01-01 00:00:00' AND '2016-06-01 23:59:59'
在想算数有
month count
01 0
02 0
03 5
04 3
05 7
06 4
如何使用拆分月明智循环使用查询。
试试这个;)
SELECT `mouth`, sum(`count`) AS `count`
FROM (
SELECT LPAD(MONTH(invoice_date), 2, '0') AS `month`, COUNT(1) as `count`
FROM sales_info
WHERE assigned_dse_name IN ('ANBHAZHAGAN .') AND invoice_date BETWEEN '2016-01-01 00:00:00' AND '2016-06-01 23:59:59'
GROUP BY MONTH(invoice_date)
UNION
SELECT LPAD(t.`month`, 2, '0') AS `month`, t.`count` FROM (
SELECT 1 AS `month`, 0 AS `count` UNION
SELECT 2 AS `month`, 0 AS `count` UNION
SELECT 3 AS `month`, 0 AS `count` UNION
SELECT 4 AS `month`, 0 AS `count` UNION
SELECT 5 AS `month`, 0 AS `count` UNION
SELECT 6 AS `month`, 0 AS `count` UNION
SELECT 7 AS `month`, 0 AS `count` UNION
SELECT 8 AS `month`, 0 AS `count` UNION
SELECT 9 AS `month`, 0 AS `count` UNION
SELECT 10 AS `month`, 0 AS `count` UNION
SELECT 11 AS `month`, 0 AS `count` UNION
SELECT 12 AS `month`, 0 AS `count`) t
WHERE t.`month` >= MONTH('2016-01-01 00:00:00') AND t.`month` <= MONTH('2016-06-01 23:59:59'))TMP
GROUP BY `month`
ORDER BY `month`
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句