November 26, 2008
Dear all,
I use sqlite3 on resource limited embedded devices, and it
provide only 250K memory for sqlite.
Now, I have a table named test_tab,whose size is 300K bytes.
If I want to copy this big table to another table, this operation will fail
because of limitde memory.
The SQL sentence as follows:
----------------------------------------------------------------------------------------------
/*
sqlite3 *db; char *sql;
tab2 is a empty table,and it has the same structure as test_tab
*/
...
...
sql = "insert into tab2 select * from test_tab order by id DESC;";
sqlite3_exec(db, sql, 0, 0, 0);
----------------------------------------------------------------------------------------------
How can do?
Can anyone answer this for me? Or give me any information .
Thank you for your reply, thanks very much!
Pc.Du
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
