Generate a Date Range in MySQL

Set @i:=0;

SELECT DATE(DATE_ADD( '2014-03-01' - INTERVAL 1 DAY, INTERVAL @i:=@i+1 DAY ) ) AS datesSeries
FROM `CS3_Statistics`.`HC_Report`, (SELECT @i:=0) r
where @i < DATEDIFF( '2014-03-07' + INTERVAL 1 DAY, '2014-03-01' )
;