SQL Query to INSERT multiple rows with SELECT
<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>