On Apr 13, 2004, at 4:22 PM, Michael Bowe wrote:
Yes, your best bet would be periodically issue an SQL command such as
"DELETE FROM vlog WHERE timestamp < whateverdate"

This should work as well:


DELETE FROM vlog WHERE timestamp < DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/



Reply via email to