title: How to copy a database table column to another database
body: <p>I am using Sequel Pro to copy data from an old database to a new one. I know you can select rows and copy them as an <code>SQL INSERT</code> etc. But the layout for my new data base has changed and I no longer want to copy all the data in the rows. I just need to be able to get specific columns. I know I could copy all the rows then cut the parts I don't want out, but that would be a lot of work as I'm working with a lot of data. Surely there's something I can run to do this? </p>
  
  <p>Here's what I want to be able to do. I have both the old database and the new one uploaded to my website so I can access them both through Sequel Pro. My old database is called old_db and the new one is called <code>wordpress</code>.</p>
  
  <p>I need to be able to select the <code>wp_users</code> table inside old_db and select the following columns, <code>ID</code>, <code>user_login</code>, <code>user_pass</code> etc. and copy them into the <code>wp_users</code> table inside my new database <code>wordpress</code>.</p>