[SQLiteJDBC] equivalent to attach in sqlitejdbc

Andy Wilbourn awilbourn at gmail.com
Wed Jan 27 08:51:50 EST 2010


If you have used the ATTACH statement you just use your alias you defined

 

So something like this:

1.       Open connection to first database

2.       Run command to attach another database ATTACH 'c:/mydata/db2.db'
AS db2

3.       Run query that joins two together, just need to use syntax of <db
alias>.<table>. So something like db2.table1 for instance of having a table
in database 2 that is named table1.



More information about the SQLiteJDBC mailing list