title: MySQL Insert 20K rows in single insert
body: <p>In my table I insert around 20,000 rows on each load. Right now I am doing it one-by-one. From mysql website I came to know inserting multiple rows with single insert query is faster. </p>
  
  <p>Can I insert all 20000 in single query?</p>
  
  <p>What will happen if there are errors within this 20000 rows? how will mysql handle that?</p>