Fill mysql column by dates

[smagdy]

Sorry i didnt find databases related discussion.. so i think here is the right place.

So is there a way to automate filling a mysql column by dates like starting from 01/01/2004 till like 31/12/2005.

to look like this..

Date¦
-----
01/01/2004
02/01/2004
03/01/2004
04/01/2004
.
.
.
31/12/2005

or ive to do it manually?

thanks in advance

[BjarneDM]

Write a commandline PHP or Perl script to take care of it.