Dear friends,


I am trying to create e "Sliding Window" effect in a mysql database. I want to be able that after a certain time from point of first timestamp, lets say after 10 minutes, I want to delete the rows of that table, means all the rows of data collected in 10 minutes period of time say ...



Could you please help me with some way how to achieve this?

Your help will be appreciated,

Thank you

please explain why you want this after only 10 minutes

deletions is something you don't need to do more than once a year

if at all