title: Stored procedure that Automatically delete rows older than 7 days in MYSQL
body: <p>I would like to know if is possible to create a stored procedure that automatically, every day at 00:00, deletes every row of every table that is over 7 days.</p>
  
  <p>I have seen few solutions but not sure if its what I am looking for, and would be nice if someone has any good example. I know this could be done with simple scripts in python and php, but I would like something more automated by MySQL.</p>
  
  <p>Any help would be really appreciate.</p>
  
  <p>Thanks!</p>