6 messages in com.mysql.lists.perlRe: Loading calendar database
FromSent OnAttachments
Jan Eden20 Dec 2004 07:34 
Jan Eden20 Dec 2004 09:18 
Peter Pentchev20 Dec 2004 22:49 
Jan Eden21 Dec 2004 00:59 
Peter Pentchev21 Dec 2004 01:40 
Jan Eden21 Dec 2004 02:00 
Subject:Re: Loading calendar database
From:Jan Eden (lis@janeden.org)
Date:12/20/2004 09:18:47 AM
List:com.mysql.lists.perl

Jan Eden wrote on 20.12.2004:

Hi,

I plan to move my Data::Dumper based occupancy table to a real database. While the database itself is quite, I am not sure how to load it with the appropriate dates (including February 29, 2008 etc).

Is there a Perl module or a certain technique for loading fields of the date type with the appropriate information?

I already thought about a loop like

for (1..1000) { $dbh->do(INSERT INTO ... VALUES ADDDATE('2004-01-01', INTERVAL $_ DAYS); }

But there must be something better.

Thanks,

Jan