title: create trigger with ' insert into.. select...' statement
body: <p>I am writing an after insert trigger which inserts data to list_of_requests table taking the data from emp_sup table. </p>
  
  <pre><code>create trigger trig_lor
  after insert 
  on employee_skillset
  for each row begin
      insert into list_of_requests (APPROVER1,APPROVER2,LOGDATE) 
      select sup1,sup2,'#dateFormat(now(),"yyyy/mm/dd")#' from empsup
          where empno=NEW.employee_number
  end
  </code></pre>
  
  <p>This is giving error as: <code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'trigger trig_lor after insert on employee_skillset for each row begin inse' at line 1</code></p>
  
  <p>How do I make this work?</p>