Re: [sqlite] UPDATE with result from subquery

2003-10-30 Thread Kurt Welgehausen
>> Date: Thu, 30 Oct 2003 12:45:17 +0100 >> From: Bart Duchesne <[EMAIL PROTECTED]> >> >> update mail set size = (select m1.size from mail m1 where m1.id = id and >> m1.sender is not null) where sender is null; Your statement doesn't work for at least 2 reasons. (1) (m1.id = id) is always true

[sqlite] UPDATE with result from subquery

2003-10-30 Thread Bart Duchesne
Hi all, I don't know if this is related to sqlite or that it is just wrong. I want to update a column in a table with a value retrieved from the same table like this: update mail set size = (select m1.size from mail m1 where m1.id = id and m1.sender is not null) where sender is null; it always

Re: [sqlite] Modifying an existing table

2003-10-30 Thread Kurt Welgehausen
>> From: "Dennis Volodomanov" <[EMAIL PROTECTED]> >> Date: Thu, 30 Oct 2003 22:04:18 +1100 >> Subject: [sqlite] Modifying an existing table >> >> Hello everybody, >> >> Is there any easy way to modify an existing table? I need to do three things: >> >> 1) add one more column >> 2) change the name

Re: [sqlite] Modifying an existing table

2003-10-30 Thread Tito Ciuro
On 30 oct 2003, at 12:04, Dennis Volodomanov wrote: Hello everybody, Is there any easy way to modify an existing table? I need to do three things: 1) add one more column 2) change the name of one column (keeping the data intact) 3) rename a table Or do I have to read in and then write out the