title: Row count after insert query and row count of select query
body: <p>I am inserting records into the table and values are taken by using select query.</p>
  
  <pre><code>insert into my_table (....) 
  select a.name, b.age, c.id, d.address 
  from table1 a, table2 b, table3 c, table4 d 
  where a.age=23 and d.addredd like '%street%';
  </code></pre>
  
  <p>I would like to compare the rowcount of select query and rowcount of my_table (after insertion).</p>
  
  <p>how to take rowcount of both without taking more processing time.</p>
  
  <p>Thanks</p>