Unix:
Create a cron job that executes a shell script to do it.
Win:
Create a scheduler job that runs a batch file.
You should be able to write a generic SQL statement that deletes all records
older than X time units. Your shell script/batch file should call mySql and
pump the script into it.
(i.e. mysql < myscript.sql )
Don't forget to put a USE statement at the top of your SQL script! :)
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
----- Original Message -----
From: "Jemand" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 7:30 AM
Subject: How to make MySQL selfdeleting old entrys?
How can i set a date or a number of seconds/hours/minutes/days, after the
date expired, that mysql deletes the entry. I want a entry that is only
shown a week, after the wekk the entry should be deleted.
Is there a way?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
