"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
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
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;
So, I think this should do it. I will give it a try and get back to the
group.
thanks all.
josé
-
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
-Original Message-
From: jose isaias cabrera <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: [sqlite] Adding data to the end of a column
Date: Wed, 30 Jan 2008 14:34:17 -0500
Greetings.
Is there a way to add data to the end of a field? I know
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?
6 matches
Mail list logo