title: sqlite data from one db to another
body: <p>I have 2 sqlite databases, and I'm trying to insert data from one database to another. For example, "db-1.sqlite" has a table '1table' with 2 columns ('name', 'state'). Also, "db-2.sqlite" has a table '2table' with 2 columns ('name', 'url'). Both tables contain a list of 'name' values that are mostly common with each other but randomized, so the id of each row does not match.</p>
  
  <p>I want to insert the values for the 'url' column into the db-1's table, but I want to make sure each url value goes to its corresponding 'name' value. </p>
  
  <p>So far, I have done this:</p>
  
  <pre><code>&gt; sqlite3 db-1.sqlite
  sqlite&gt; alter table 1table add column url;
  sqlite&gt; attach database 'db-2.sqlite' as db2;
  </code></pre>
  
  <p>Now, the part I'm not sure about:<br></p>
  
  <pre><code>sqlite&gt; insert into 1table(url) select db2.2table.url from db2.2table where 1table.name==db2.2table.name
  </code></pre>
  
  <p>If you look at what I wrote above, you can tell what I'm trying to accomplish, but it is incorrect. If I can get any help on the matter, I'd be very grateful!! </p>