title: mysql trigger with insert and update after insert on table
body: <pre><code>create table Test1
  (
  WRO varchar(10),
  Test_No varchar(10),
  TestDate datetime
  );
  
  insert into Test1(WRO,TestDate) values('T0001',now());
  
  create table Test2
  (
  WRO varchar(10),
  Test_No varchar(10),
  Test2Date datetime,
  TestAmount varchar(10)
  );
  </code></pre>
  
  <p>I have to update and Insert on Test1 Test_No after insert on Test2 table Test_No both have common field WRO. </p>
  
  <pre><code>insert into Test2 values('DSK','400',now(),3000);
  insert into Test2 values('T0001','200',now(),3000);
  </code></pre>
  
  <p>if wro no of test2 table not match with test1 then insert query should be fired in test1 table </p>