[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