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