Delete old ecards in mysql automatically..

[Guest_imported]

Hi,I am kinda working on an e-card program.Everything's just fine...but I hope I could let those old ecards remain in MySQL (say those exceed 14 or 30 days) to be deleted automatically.Could anyone please help me figure out this?Thank you very much.

 

[KarveR]

DELETE from ecard_table where created_date >= date_sub(curdate(), interval 14 day);

Enjoy.

//Karv ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[sleipnir214]

As far as automatic deletion goes, use KarveR's SQL statement and wrap it in a perl script. Then use cron to perform the deletion every night. ______________________________________________________________________
Did you know?
The quality of our answers is directly proportional to the number of stars you vote?