Auto Delete

[Anon]

if i have some data that should be deleted four days later, what syntax should I type ?

this should be "Select * from blabla from tablename where ? "

so how could i embed the "timer" ?

thx

[Anon]

what about inserting a datetime field in this table (to be filled with the date at the moment of insertion), and using a daily cron triggered script deleting from this table where date<now minus 4 days...

I know, i know, this is no code, just an idea 🙂

[Anon]

if you could give some details about how to use cron to insert, update delete mysql tables, i would appreciate it. i would probably be very useful for lots of folks. tia.

[Anon]

cron is a way to launch automatically some job at a given time under unix.

Lets suppose you have a script (php may do the trick but perl or simple bash will be ok too) that do what you need.

/home/bart/bin/sqljob

Log in as bart, or any user that is allowed to use the script (as the connection to the database shall require a password, be sure that the file is not readable to everybody).

Launch crontab -e, this will open an editor (usually vi) that let you tell what you need to be launch and when.

Each line of a crontab contains 5 fields followed by a script name.

the fields are:
minute
hour
day of month
month
day of week

someting like:
* /home/bart/bin/sqljob

will launch sqljob each minutes

0 12 * /home/bart/bin/sqljob
will launch it every day at 12h00

You can use more subtle syntax like 1-5 (meaning 1,2,3,4,5) or 1-6/2 (meaning 1 3 5)
to launch the script exactly when you need.

More information with man crontab (5).

Hope this helps.

[Anon]

try man cron