title: Mysql doesn't return the correct id of the inserted row
body: <p>I use <a href="https://github.com/mysqljs/mysql" rel="nofollow noreferrer">Mysqljs</a> in a project. That Mysqljs libray has a feature to get the id of an inserted row.</p>
  
  <blockquote>
    <p>If you are inserting a row into a table with an auto increment primary
    key, you can retrieve the insert id like this:</p>
    
    <p>connection.query('INSERT INTO posts SET ?', {title: 'test'}, function
    (error, results, fields) {   if (error) throw error;<br>
    console.log(results.insertId); });</p>
  </blockquote>
  
  <p><strong>But the wired thing in here is</strong>, it doesn't return the correct inserted id.</p>
  
  <p>I imported my database from a script (without data only structure) but it still takes the old inserted ids I guess.</p>
  
  <p>I have a table called <code>item</code>
  first time I inserted, it returns the <strong>insertId as 143</strong> even through I can see the id field for my first record is inserted to table as 1.</p>
  
  <p>How do I fix this?</p>