title: if condition in trigger
body: <p>i have a tow table name t1,t2 . Based on the value insert in t1 i want to insert in t2 .
  i use the following trigger . </p>
  
  <pre><code>create trigger testt after insert on t1
  BEGIN
  for each row
  if NEW.uid='Mill' then insert into t2 (uid2) values (NEW.uid)
  end if
   if NEW.uid='Farm' then insert into t2 (uid2) values (NEW.r)
  end if
  END
  </code></pre>
  
  <p>Please help me to resolve this issue . Thanks in advance</p>