>> 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
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
>> 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
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
4 matches
Mail list logo