On 09/08/2016 12:57 AM, Clay Gerrard wrote:
On Wed, Sep 7, 2016 at 10:08 AM, Dan Kennedy <danielk1...@gmail.com> wrote:
[...] then attach it and your main db to the same handle so that you can
use an "INSERT INTO ... SELECT ..." statement
Can you elaborate or provide any reference materials for this "attach it
and your main db to the same handle" procedure? Very interesting!?
Use the ATTACH SQL command:
http://sqlite.org/draft/lang_attach.html
If you're second db is "x.db" you can do something like:
ATTACH 'x.db' AS aux;
and then:
SELECT * FROM aux.sqlite_master;
and so on.
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
