title: MySQL LAST_INSERT_ID() used with multiple records INSERT statement
body: <p>If I insert multiple records with a loop that executes a single record insert, the last insert id returned is, as expected, the last one. But if I do a multiple records insert statement:</p>
  
  <pre><code>INSERT INTO people (name,age)
  VALUES ('William',25), ('Bart',15), ('Mary',12);
  </code></pre>
  
  <p>Let's say the three above are the first records inserted in the table. After the insert statement I expected the last insert id to return 3, but it returned 1. The first insert id for the statement in question.</p>
  
  <p>So can someone please confirm if this is the normal behavior of <code>LAST_INSERT_ID()</code> in the context of multiple records INSERT statements. So I can base my code on it.</p>