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 MyOtherDatabase.MyTable where ...)
Martin Pierre Chatelier schrieb: > 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 one side and > INSERT on the other. But since one of my column is a blob type, it is > a little more pain than a simple string copy, because for performance > I should have to handle the blob with the read/write functions. Right ? > > Anyway, are there tricks to know to make such a row transfert simple > and efficient ? > > Regards, > > Pierre Chatelier > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
