title: mysql trigger - select count(*) from trigger
body: <p>I want to count rows created/inside (dont know what it is called) a trigger.</p>
  
  <p>like i have a trigger :</p>
  
  <pre><code>CREATE
  DEFINER=`root`@`localhost`
  TRIGGER `mydb`.`tn_air_staff_leave_application`
  AFTER INSERT ON `mydb`.`staff_leave_application`
  FOR EACH ROW
  BEGIN
  ----
  ----
  ----
  END$$
  </code></pre>
  
  <p>and want to know how many rows trigger is going to create, I need this value inside trigger:</p>
  
  <pre><code>set @newrows:= (select count(*) from tn_air_staff_leave_application); 
  </code></pre>
  
  <p>is it possible?? if not any other solution out there???</p>