On 17-05-2012 11:04, YAN HONG YE wrote:
> I have two db files:
>
> sqlite3 *db1;
> sqlite3 *db2;
> rc1 = sqlite3_open("myfile1", &db1);
> rc2 = sqlite3_open("myfile2", &db2);
>
> I want to copy db1.table1 to db2 file, but I don't know how to do?
sqlite myfile1
sqlite> attach database 'myfile2' as db2;
sqlite> create table db2.table1 as select * from main.table1;
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
