[thelist] Expiring records in MySQL
Jonathon Thomas
jthomas at firstnet.net.uk
Fri May 10 10:40:01 CDT 2002
Daniel
As far as I know this isn't possible.
However (I'm assuming you're running on unix), you could set up a daily
cron job to call a simple perl script which executed the following
query:
Delete from [tablename] where [expiry] < now()
[tablename] is obviously the name of your table, and [expiry] is a
DATETIME column containing the expiry date.
Cheers
Jon
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org] On Behalf Of Daniel Fascia
Sent: 10 May 2002 16:02
To: thelist at lists.evolt.org
Subject: [thelist] Expiring records in MySQL
Importance: High
Is it possible to make entries into a MySQL database (+ PHP) which
expire and
are therefore autoremoved when their allocated date arrives?
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list