title: Delete from MySql table after limited time
body: <p>I have a that that stored some posts, and I would like the to delete these posts after a limited time, like 1hour or something.</p>
  
  <p>The thing is a have a site where you need to signup, and before you register you need du verify your email by click on a link that got send from the site. And that link is stored in this temporary table. </p>
  
  <p>So thing is I want the post (which contain the link) to get deleted from there after a limited time.</p>
  
  <p>the table </p>
  
  <pre><code>$createCommentsTable = "CREATE TABLE comments(
  id INT NOT NULL AUTO_INCREMENT,
  inlagg_id INT,
  namn VARCHAR(30),
  kommentar VARCHAR(200),
  date VARCHAR(40),
  PRIMARY KEY (id)
  )";
  </code></pre>