title: insert multiple tables from a mysql trigger
body: <p>running MySQL 5.5.8 I want to insert records into multiple tables via trigger. here is my trigger so far:</p>
  
  <p>CREATE TRIGGER userlevel_insert
  AFTER INSERT ON db.tablename
  FOR EACH ROW 
    INSERT IGNORE INTO db.differenttable (col1,col2) VALUES (NEW.val1,2);</p>
  
  <p>This works. no issue. However i want the insert to hit multiple tables. the table is actually the same structure, but in different databases. The following throws an error:</p>
  
  <p>CREATE TRIGGER userlevel_insert
  AFTER INSERT ON db.tablename
  FOR EACH ROW 
    INSERT IGNORE INTO db.differenttable (col1,col2) VALUES (NEW.val1,2);
    INSERT IGNORE INTO db.secondtable (col1,col2) VALUES (NEW.val1,2);</p>
  
  <p>The error is:
  Error Code: 1054
  Unknown column 'NEW.val1' in 'field list'</p>
  
  <p>So how can i use a trigger to insert the same data into multiple tables?</p>