SQLite's multi-table connection update

Recently processing a large data of the SQLite library, the base table 3 million, the results table 300,000 about, my notebook run up is smooth. Finally, we need two tables to connect and update the results of the other table, but there is a problem. Sqliter does not support common connection updates:

Update a set a.id =b.id from Table_1 a inner joins table_2 B on  a.name=b.name

Check it out, only this:

Update table1 Set col1= (select col1 from table2 where col2=table1.col2)

Try it, it's too slow.

Finally find a way to compromise:

1. Write the connection as a view

2. Export Results to CSV

3. Create an empty table with the same structure and view

4. Import the CSV into the empty table

5. Trimming the related columns

SQLite's multi-table connection update