Copying two columns from one table to another
<p>Couldn't find exactly what I'm looking for anywhere else.</p>

<p>So I have table 1</p>

<pre><code>users
----------

id
username
password
bio
isuser
email
</code></pre>

<p>and table 2</p>

<pre><code>wp_users
----------

id
user_login
nice_username
password
email
</code></pre>

<p>There are 500 rows in 'wp_users' table. I would like to copy 'id' and 'user_login' into the users table ('id' and 'username') for each row.</p>

<p>How can I do this? MySQL isn't my strong point lol.</p>

<p>UPDATE: I have updated the tables above as I tried to simplify it but in return got the wrong solution.</p>