Hi all, Many thanks for your kindly reply. I will start using SQLite today.. ;-)
Cai Yuan ----- Original Message ----- From: "Darren Duncan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 16, 2004 7:13 AM Subject: Re: [sqlite] Update in SQLite > At 1:28 AM +0800 8/15/04, 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) > >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
