title: MySql: delete content from table before last month
body: <p>I'm using Mysql 5.5.  I want to delete content from a table on MySql. I <strong>only</strong> want  to delete content that are before last month.  It means we are on " Wed Aug  6 04:37:48 EDT 2014 " and I want to delete all content except last month.</p>
  
  <p>What is the query that will do this for me?  I used this query:</p>
  
  <pre><code>delete from TABLE_NAME
  where TIMESTAMP_COLUMN &lt; UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 day))
  </code></pre>
  
  <p>and the result was:</p>
  
  <blockquote>
    <p>Query OK, 31869117 rows affected (41 min 24.96 sec)</p>
  </blockquote>
  
  <p>But in Phpmyadmin, I see the volume of table stile 5 Gig!</p>