Mailing List Archive


Back to the month index Back to the list index
Peter Kosenko (kosenko@netwood.net)
Wed, 09 Apr 1997 16:36:27 +0000 

Message-Id: <334BC58B.645A@netwood.net>
Date: Wed, 09 Apr 1997 16:36:27 +0000
From: Peter Kosenko <kosenko@netwood.net>
Subject: Re: [mSQL] Automatic Delete

Ewan Maclennan wrote:
>
> Hi,
> Could anyone tell me whether it is possible to delete data from the
> database by setting some kind of time limit on the time the data is
> stored in the database?
>
> Thanks
> Ewan

This message bounced the first time, so here it is again.

Ewan:

B. Scott Burkett has developed a utility.

Follow this link:

http://www.dcicorp.com/~burkebs/projects.html

Description:

msqlexpire

The msqlexpire utility is an age-based row/record expiration utility for
use with the UNIX-based mSQL Database Engine by David J. Hughes. It can
automatically expire (DELETE) records based on age, with optional
e-mail notification of record removal. Our company currently uses this
tool to automatically remove outdated job requirements from our
web-based Career-Retrieval System.

Peter Kosenko
kosenko@netwood.net
http://www.netwood.net/~kosenko/

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!