有没有用过SQLite的高手啊?我这样写不行,求一条不同数据库间复制表的语句,
有两个SQLite数据库文件, c:\\a.s3db c:\\b.s3db 我想把c:\\a.s3db里的某一个表oldTb复制到c:\\b.s3db 里,更名为newTb
.......
TASQLite3DB *ASQLite3DB=new TASQLite3DB(NULL);
ASQLite3DB->Database="b.s3db ";
ASQLite3DB->DefaultDir="c:\\";
ASQLite3DB->DriverDLL="c:\\sqlite3.dll";
ASQLite3DB->SQLite3_ExecSQL("select * into newTb from [;DATABASE=c:\\a.s3db].oldTb where 1=2");
......
[解决办法]
没有弄过,关注。。。
[解决办法]
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>