On Tue, 13 Apr 2004, Tom Collins wrote:
> 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
On 5.3.x, timestamp is in unix timestamp format, so you'll need something
like "DELETE FROM vlog WHERE timestamp <
Is using a MySQL DATETIME type new in 5.4.x?
> 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/