title: copy data from one table to another @mysql database every 5 secs
body: <p>Hello Everyone,
                I am building up a webpage using asp.net which will populate data from a table@ my sql database. I need to copy data from one table to another for history purpose every 5 secs.
  My question: how can I implement a sql script which will run continuously on server, check and insert data  from one table to another so that my webpage will refresh latest data every 5 secs? Also, is it possible to implement using asp.net only even if webpage is not opened?</p>
  
  <p>This is my 1st  web project so please bear with me. Responses are highly appreciated!</p>