Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Unanswered: MySql Sliding Window effect

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •