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;
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
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
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
4 matches
Mail list logo