Code: Select all
SELECT COUNT(*) AS items_recd FROM `items_in`
WHERE MONTH(`dt_created`) = MONTH(CURRENT_DATE())-1;
< /code>
Ich gehe davon aus Wie kann ich reparieren?SELECT COUNT(*) AS items_recd FROM `items_in`
WHERE MONTH(`dt_created`) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH);
Code: Select all
SELECT COUNT(*) AS items_recd FROM `items_in`
WHERE MONTH(`dt_created`) = MONTH(CURRENT_DATE - INTERVAL 2 MONTH);