On Sun, Aug 15, 2004 at 01:28:05AM +0800, cai yuan wrote: >"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!
No, the docs are talking about altering the definition of a table, not updating a row. Dave Cook