没有用过SQLite的高手啊？求一条不同数据库间复制表的语句,
有两个SQLite数据库文件，　c:\\a.s3db　c:\\b.s3db 我想把c:\\a.s3db里的某一个表oldTb复制到c:\\b.s3db 里，更名为newTb




[解决办法]

BatchFile code

C:\temp>sqlite3 db1SQLite version 3.6.7Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite> .tablest1  txsqlite> select * from t1;1|A2|Bsqlite> .qC:\temp>sqlite3 db2SQLite version 3.6.7Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite> .tablessqlite> ATTACH DATABASE db1 as db1;sqlite> select * from db1.t1;1|A2|Bsqlite> create table t2 as select * from db1.t1;sqlite> select * from t2;1|A2|Bsqlite>