title: How Do I record the execution time of running sql statements that are stored in files?
body: <p>I am doing something related to TPC-H.</p>
  
  <p>I've got sql statements in several files. I need to execute them and record the execution time like this:</p>
  
  <pre><code>13 rows in set (0.00 sec)
  </code></pre>
  
  <p>I also need the result sets to see if I got the correct result.<br>
  My platform is linux(centOS).</p>
  
  <p>If I do this manually I will type statements like this in mysql:</p>
  
  <pre><code>  shell&gt; mysql -u tpch -p
    mysql&gt; use tpch;
    mysql&gt; source /home/liova/download/tpch/queries/Q1.sql;
    mysql&gt; source /home/liova/download/tpch/queries/Q2.sql;
  </code></pre>