Re: [sqlite] how to access tables in multiple sqlite databases

Hi, see http://www.sqlite.org/lang_attach.html you attach a second database, giving it a name, and prepend this name to the table name. Martin Zhenyu Guo schrieb: > Hi guys, > > I have multiple sqlite databases in hand, and I would like to perform the > following several tasks: > > . two

[sqlite] how to access tables in multiple sqlite databases

Hi guys, I have multiple sqlite databases in hand, and I would like to perform the following several tasks: . two tables with the same schema are in two dbs, and I want to apply a sql query to the two tables efficiently (merge them into one table? Merge cost is also considered as the total