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

2007-05-02 Thread Robert M . M√ľnch
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

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

2007-04-24 Thread Dennis Cote
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

2007-04-24 Thread drh
"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

2007-04-24 Thread Yuriy Martsynovskyy
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