Hi, I would like to test the SQLite in some linux embedded system. I read the limitation document and it says "To change a table you have to delete it (saving its contents to a temporary table) and recreate it from scratch." (Stated in http://www.hwaci.com/sw/sqlite/omitted.html) Does it mean when I use the "UPDATE ..." SQL statement, the table will actually be deleted and recreated by SQLite automatically? Thanks!
Regards, Cai Yuan