Help with MySQL

[Anon]

Hello every body

I hope you guys can help me out

I have a Table in MySQL but what i want to do is to give a life time to the rows i insert, lets say 3 hours, and when the
time has expired the row has to be deleted.

I would really apresiate your help

Sincerely
Julio Pastrana

[vandana]

hi
not much idea about MYSQL, but u can sure write script to do the same

first store the time of insertion into the table
then write a script that checks this insertion time against the current time and deletes the entry if the difference is more than 3 hrs.
u can set this script as a cron job

[[deleted]]

That is the only way to do it because there are no "self deleting records" in databases.

[Anon]

I am going to try that
thanks a lot guys