"P Kishor" wrote...
On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
Punkish,
I don't want to replace it. I want to add to the end of field. So, I
did
not know that I could do,
UPDATE table SET field = field && 'data to be added' WHERE id = 55;
first, you should use || as the string concat operator, although &&
might also work. I haven't tried it though.
That said, I hate to tell you that whether you do
field = field || 'data to be added'
or given
field = 'value'
you do
field = 'value with more text'
you are replacing the value of the field, and that was what I was
trying to illustrate. I should have really said
field = field || ' with more text'
Ok, just to complete this thread, this works,
UPDATE table SET field = field || 'data to be added' WHERE id = 55
thanks.
josé
So, I think this should do it. I will give it a try and get back to the
group.
thanks all.
josé
----- Original Message -----
From: "P Kishor" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, January 30, 2008 2:59 PM
Subject: Re: [sqlite] Adding data to the end of a column
> replace the field with new value.
>
> UPDATE table SET field = 'value with more data' WHERE field = 'value'
>
> On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
>>
>> Greetings.
>>
>> Is there a way to add data to the end of a field? I know I select
>> that
>> field, import the data into a variable and then add whatever to the
>> end.
>> What I am trying to do is exactly NOT that. :-) So, instead, just add
>> say a
>> line or two of text to a field.
>>
>> Is this possible?
>>
>> thanks,
>>
>> josé
>>
>>
>> -----------------------------------------------------------------------------
>> To unsubscribe, send email to [EMAIL PROTECTED]
>> -----------------------------------------------------------------------------
>>
>>
>
>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
