From sqlite-users  Fri Jan 09 08:21:26 2009
From: Chris Wedgwood <cw () f00f ! org>
Date: Fri, 09 Jan 2009 08:21:26 +0000
To: sqlite-users
Subject: Re: [sqlite] Transfer data between databases
Message-Id: <20090109082126.GA208466 () puku ! stupidest ! org>
X-MARC-Message: https://marc.info/?l=sqlite-users&m=123150225428806

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;
[...]
INSERT INTO fromdb.tablename SELECT * FROM src;


(attach & prefix 'src' as needed)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users