¡@
php Programming Glossary: thedateFilling Gaps in Dates Returned from Database - pure SQL solution possible? http://stackoverflow.com/questions/5059380/filling-gaps-in-dates-returned-from-database-pure-sql-solution-possible drop table if exists datetable create table datetable thedate datetime primary key isweekday smallint SET @x date '1900 01.. SET @x date '1900 01 01' REPEAT insert into datetable thedate isweekday SELECT @x case when dayofweek @x in 1 7 then 0 else.. be just SELECT COUNT t.click_date as clicks DATE_FORMAT thedate ' d M Y' as point FROM Dates LEFT JOIN tracking t ON t.click_date..
|