插入大量日期

Question

How can I insert all dates in an year(or more) in a table using sql

My dates table has following structure

dates(date1 date);

Suppose I want to insert dates between "2009-01-01" to "2010-12-31" inclusive.

Is there any sql query for the above?

Answer 1

Well, you can do a simple loop:

$start = mktime(12,0,0,1,1,2009);
$end = mktime(15,0,0,12,31,2009);

$values = array();
for($time = $start; $time <= $end; $time += 86400) {
    $values[] = date('Y-m-d', $time);
}

$query = "INSERT INTO dates(`date`) VALUES ('".implode("'), ('", $values)."')";

mysql_query($query);