[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Transfer data between databases
From:       Chris Wedgwood <cw () f00f ! org>
Date:       2009-01-09 8:21:26
Message-ID: 20090109082126.GA208466 () puku ! stupidest ! org
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]