Mailing List Archive


Back to the month index Back to the list index
rossg@cpd.co.uk
Thu, 10 Apr 1997 11:07:40 +0000 (GMT) 

From: rossg@cpd.co.uk
Message-Id: <199704101107.LAA00788@rossg.dial.nildram.co.uk>
Date: Thu, 10 Apr 1997 11:07:40 +0000 (GMT)
Subject: Re: [mSQL] Automatic Delete

-----BEGIN PGP SIGNED MESSAGE-----

On a previous occasion, "Joshua J. Kugler" <jkugler@inreach.com> wrote:
> > 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?
>
> As far as I know, I don't think so, because mSQL doesn't have a 'date'
> field type.
>
> What you could do is put the date, e.g. 04/09/1997 in a field when a
> record

Alternatively, store the date as a number, either as YYYYMMDD, or as
'seconds since epoch' or similar. Then old records could be removed
simply by:-

DELETE FROM table WHERE datefield < '961231'

- --
Ross Golder
Technical Dept
CPD Ltd, Whetstone, London, N20 9LD.
Tel: +44 (0) 973 897671
mailto:rossg@cpd.co.uk (Work)
http://www.cpd.co.uk/~rossg

-----BEGIN PGP SIGNATURE-----
Version: 2.6.3i
Charset: noconv

iQB1AwUBM0zKBMCXlpP9iL6tAQEuggL+OrEsNZUUh58t1ldFI9aVCHz2xeXd+Kn6
JG2z5TLOXM+fPnFgp40lTyvYgdS9E1iTTnkH3+bs7VBzo84DbQ+1TikqLD+80eQX
xoaeWEVedcmVLAhywHX+rkuDw8Rk1qV1
=spzU
-----END PGP SIGNATURE-----
--------------------------------------------------------------------------
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!