title: How to get the count of inserted rows in "insert ignore stament"
body: <p>I am doing bulk insert and inserting 0.5 million  tokens in the database with insert <code>"ignore statement"</code>. in 0.5 million  tokens there can be duplicate tokens.
  so if i insert 0.5 million tokens in the database with insert ignore statement then there is no guarantee that all of tokens are inserted into the database because of duplicate tokens.</p>
  
  <p>After doing insertion i want to know how many tokens are inserted into the database. some people are suggesting to use <code>affected_rows</code> columns to get count of inserted (affected) rows. But affected_rows doesn't give the output of current sql statement it gives the output of last sql statement. </p>
  
  <p>Please tell me the best way to get count of inserted rows with insert ignore statment.</p>