Re: [sqlite] Copy records from one DB to another

On Tue, 24 Apr 2007 19:57:31 +0200, Yuriy Martsynovskyy <[EMAIL PROTECTED]> wrote: What is the best way to copy records between tables located in different DB files? Hi, I want to extend this question: How to best copy records from one database (linked via different tables) to an other dat

Re: [sqlite] Copy records from one DB to another

Yuriy Martsynovskyy wrote: What is the best way to copy records between tables located in different DB files? Both DBs have completely the same structure. I need to add records from table in DB1 to table in DB2. Logically something like this: INSERT INTO .table1 SELECT * FROM .table1 Yuriy,

Re: [sqlite] Copy records from one DB to another

"Yuriy Martsynovskyy" <[EMAIL PROTECTED]> wrote: > What is the best way to copy records between tables located in > different DB files? > Both DBs have completely the same structure. I need to add records > from table in DB1 to table in DB2. Logically something like this: > > INSERT INTO .table1 >

[sqlite] Copy records from one DB to another

What is the best way to copy records between tables located in different DB files? Both DBs have completely the same structure. I need to add records from table in DB1 to table in DB2. Logically something like this: INSERT INTO .table1 SELECT * FROM .table1