I want to add a row in a table, but have it deleted after like 10 minutes...how can I do this?
Thanks, Andrew
if you are going through php you could... $currenttime = time(); mysql_query("Insert into tablename (time) Values ('$currenttime')"); then when you are accessing the chart throught php you could first... $deletetime = time() - 600; mysql_query("delete from tablename where time < '$deletetime'"); then do the rest of whatever you were doing
I need it to be automatic, but thanks anyways.
I am pretty sure there has to be something so that the row "expires" after a certain amount of time
You could put the results into a temporay table. This dies as soon as your connection dies. You also need mysql 3.23.02 or higher.
Otherwise you need to run a cron job every few minutes to check.
