Hi Simon, Thanks for that. Can I just check something. When you say " Don't forget to DELETE FROM before you insert your new rows " I assume that you're saying to make sure that the target table is empty before I do the insert. Yes?
Cheers, Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: http://www.ward-analytics.com Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United Kingdom, GU1 3SR Registered company number: 3917021 Registered in England and Wales. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: 10 November 2013 18:32 To: General Discussion of SQLite Database Subject: Re: [sqlite] Combining two databases into one 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
