On 10 Nov 2013, at 5:49pm, Dave Wellman <dwell...@ward-analytics.com> wrote:

> Ah! I may have just found the answer. If I've got databases db1 and db2
> attached, can I use something like 'insert into db1.t1 select * from
> db2.t1;' (assuming that the 't1' definitions are the same !)?

That's the best way I know of to do it, bearing in mind your entire 
requirements.  I don't see anything else wrong with your proposed procedure.  
Don't forget to DELETE FROM before you insert your new rows.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to