Mailing List Archive


Back to the month index Back to the list index
Peter Samuel (psamuel@ind.tansu.com.au)
Thu, 10 Apr 1997 11:20:24 +1000 (EST) 

Date: Thu, 10 Apr 1997 11:20:24 +1000 (EST)
From: Peter Samuel <psamuel@ind.tansu.com.au>
Subject: Re: [mSQL] Automatic Delete
Message-Id: <Pine.GSO.3.96.970410112010.1599F-100000@grizzly.ind.tansu.com.au>

On Wed, 9 Apr 1997, Peter Kosenko wrote:

> 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.
>

This too is in the FAQ.

Regards
Peter
----------
Peter Samuel peter@uniq.com.au
Technical Consultant or at present:
Uniq Professional Services Peter.Samuel@ind.tansu.com.au
Phone: +61 2 9206 3439 Fax: +61 2 9281 1301

--------------------------------------------------------------------------
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!