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
UPDATE ... works fine.
ALTER ... is what does not work. The comment you were looking at was talking about ALTER.
-- Darren Duncan