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