On Saturday 14 August 2004 10:28 am, cai yuan wrote: > 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)
That limitation refers to altering the structure of a table, not changing the data in a table. > Does it mean when I use the > "UPDATE ..." SQL statement, the table will actually be deleted and > recreated by SQLite automatically? Thanks! No, update is an SQL statement used to change values stored in a row or rows in the table. It works on the 'data' stored in the table, not the table structure itself. Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.5-7.104-default x86_64
