[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