title: creating mysql dump like phpMyAdmin
body: <p>I have a scripts that retrieves huge data on a table. I want to create a mysqldump to insert data into another database table with different fields. I want the format of phpMyAdmin where it repeats the INSERT INTO Table VALUES(values1),(values2), ...(values100); if reaches certain amount of value sets depends on what you set. </p>
  
  <p>ex: If I have 550 data sets and i want to be devided the data by 100 so that i will have 6 sets of INSERT INTO query.</p>
  
  <pre><code>INSERT INTO tablename VALUES(value1), (value2), .... (value100);
  INSERT INTO tablename VALUES(value101), (value102), .... (value200);
  INSERT INTO tablename VALUES(value201), (value202), .... (value300);
  INSERT INTO tablename VALUES(value301), (value302), .... (value400);
  INSERT INTO tablename VALUES(value401), (value402), .... (value500);
  INSERT INTO tablename VALUES(value501), (value502), .... (value550);
  </code></pre>