title: INSERT INTO COUNT(*) updating timestamp automatically in MYSQL
body: <p>How can i run the below query with the following table structure under test_reports</p>
  
  <p>Table_Name
  Date (Current TimeStamp)
  Total_Count</p>
  
  <pre><code>INSERT INTO test_reports SELECT "table1", "date", COUNT(*) from `table1`;    
  </code></pre>
  
  <p>The above works fine apart from the time stamp is not updated and remains 00:00:00 </p>