how to clear a data in database older than 1 months in mysql(xamp) database

[shashigowda]

i want to clear all data in databse automatically for everymonth.iam using xampp.

[pritaeas]

Add a timestamp in every table and use that to determine whether or not it should be deleted.

[shashigowda]

sorry....will you please write one example query

[pritaeas]

It's not that simple.

1. Add a timestamp column to the tables you want to do this for.
2. Make sure that when you insert a new record this date gets filled.
3. Create a query to run at regular intervals to remove all records with old dates.

[shashigowda]

thnk you.

[shashigowda]

thank you so much
i have finishd 1st & 2nd step.
but strugling in 3rd step (i,e Create a query to run at regular intervals to remove all records with old dates.).bcoz i dont no hoew to write a query tat automaticaly execute

[pritaeas]

https://dev.mysql.com/doc/refman/5.1/en/create-event.html