title: Inserting duplicated MySQL test data the easy way?
body: <p>Rather than creating row after row of test data one at a time, is there a query I could run in MySQL to do the following:</p>
  
  <p>Table name: my_table
  Rows consist of: ID (auto-incremental), fname, lname, email, phone</p>
  
  <p>The test data should be duplicated into 100 rows, where the data would be:</p>
  
  <pre><code>1   John   Doe   jdoe@jdoe.com   0000000  
  2   John   Doe   jdoe@jdoe.com   0000000  
  ...  
  100   John   Doe   jdoe@jdoe.com   0000000  
  </code></pre>
  
  <p>Thanks!</p>