title: SQL Query to INSERT multiple rows with SELECT
body: <p>I need to read data from one table and insert into multiple rows in another table in a MySQL database.</p>
  
  <p><strong>Table 1 looks like</strong>:</p>
  
  <pre><code> ID, name, e-mail, phone, city, ..., ....
  </code></pre>
  
  <p><strong>In Table 2 I need to insert data like:</strong></p>
  
  <pre><code> (row1) ID, "name", name
      (row2) ID, "e-mail, e-mail
      (row3) ID, "phone", phone
      ...
      ...
  </code></pre>
  
  <p>Table 1 has about 3000 rows </p>
  
  <p>I guess I need to use some kind of foreach or do..while but can't find anything that works. 
  Can anyone give me a clue how to do this?</p>