Re: [sqlite] Transfer data between databases

2009-01-09 Thread Chris Wedgwood
On Fri, Jan 09, 2009 at 09:18:09AM +0100, Pierre Chatelier wrote: > I have two separate SQLite database files, but containing the same > kind of tables. Is there a quick way to copy rows from one table of > a file to the same table of the other file ? ATTACH DATABASE 'fromdb.sqlite' AS fromdb;

Re: [sqlite] Transfer data between databases

2009-01-09 Thread Martin.Engelschalk
Hi Pierre, you can open both database files at the same time and using the same connection: Look at the attach - Command: http://www.sqlite.org/lang_attach.html You can then use both databases in the same statement (insert into MyTable (... columns ...) select ... columns ... from

Re: [sqlite] Transfer data between databases

2009-01-09 Thread Simon Davies
2009/1/9 Pierre Chatelier : > Hello, > > This may be a question with a very short answer... > I have two separate SQLite database files, but containing the same > kind of tables. Is there a quick way to copy rows from one table of a > file to the same table of the other file

[sqlite] Transfer data between databases

2009-01-09 Thread Pierre Chatelier
Hello, This may be a question with a very short answer... I have two separate SQLite database files, but containing the same kind of tables. Is there a quick way to copy rows from one table of a file to the same table of the other file ? I suppose "no", and I will have to perform SELECT on