Re: Loading calendar database
Peter Pentchev <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
On Mon, Dec 20, 2004 at 06:19:09PM +0100, Jan Eden wrote:
> 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.
I think it would really help if you told us how the data is *currently*
stored :)
G'luck,
Peter
--
Peter Pentchev [email protected] [email protected] [email protected]
PGP key: http://people.FreeBSD.org/~roam/roam.key.asc
Key fingerprint FDBA FD79 C26F 3C51 C95E DF9E ED18 B68D 1619 4553
I am the meaning of this sentence.
signature.asc
(application/pgp-signature, 187 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (FreeBSD) iD8DBQFBx8eP7Ri2jRYZRVMRAs0RAJ9kZMeGyqrWq1LCiXTxVEx085ijPACePtSZ SQNtd8uiMZtmbtxcgWOleEE= =Kw1W -----END PGP SIGNATURE-----