Това си плаче за съхранена процедура:

CREATE TEMPORARY TABLE temp (d DATE);

INSERT INTO temp VALUES('2006-08-01'), ('2006-08-02'), ('2006-08-03'), ('2006-08-04'), ('2006-08-05'), ('2006-08-06'), ('2006-08-07'), ('2006-08-08'), ('2006-08-09'), ('2006-08-10'), ('2006-08-12'), ('2006-08-12'), ('2006-08-13'), ('2006-08-14'), ('2006-08-15'), ('2006-08-16'), ('2006-08-17'), ('2006-08-18'), ('2006-08-19'), ('2006-08-20');


SELECT temp.d AS myDate, IFNULL(t.mySum, 0) AS mySum
FROM temp LEFT JOIN
(SELECT SUM(int_field) AS mySum, date_field AS myDate
FROM myTable
WHERE date_field BETWEEN '2006-08-01' AND '2006-08-20'
GROUP BY date_field) AS t
ON(temp.d = t.myDate);

DROP TABLE temp;





Между другото MySQL сортира по подразбиране според GROUP BY клаузата

Съдържаниет е скрито
Влезте за да го видите