title: mysql getting last_insert_id() in a trigger
body: <p>It's my understanding that when you call last_insert_id() it goes by connections, so you'll get the id of the last row inserted on the same connection where last_insert_id() is called, right?  </p>
  
  <p>So what if I call last_insert_id() in an 'AFTER INSERT' trigger?</p>
  
  <p>What I want to do is basically this</p>
  
  <pre><code>DELIMITER $$
  CREATE TRIGGER sometrigger
  AFTER INSERT ON sometable
  BEGIN
    INSERT INTO anothertable (id, lastup) VALUES (last_insert_id(), NOW());
  END $$
  </code></pre>
  
  <p>It's very important that the id in 'anothertable' is the same as in 'sometable'
  Would this work or should I create a stored procedure instead that inserts into both tables?  </p>
  
  <p>Or possibly there is some, in the trigger, to get the values from the insert statement that caused the trigger to fire? I haven't found anything about that.</p>