有两个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>