On Sat, 7 Mar 2009 14:22:28 +0800, kin foo <kevintong....@gmail.com> wrote:
>Hi I'm wondering if it is possible to import a table from an SQLite database >to another SQLite database. >Thanks! ATTACH DATABASE 'database2.db' AS db2; CREATE TABLE table1 AS SELECT x,y FROM db2.table2; DETACH DATABASE db2; http://www.sqlite.org/lang_createtable.html -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
