Re: [sqlite] Re: Re: Re: how do i declare and use variables in sqlite?

Igor Tandetnik wrote: Paul Harris <[EMAIL PROTECTED]> wrote: anyway, this is what i'm trying to do: eg 1 select @somevar := column1 from table1; update table2 set column2 = @somevar; update table2 set column2 = (select column1 from table1); Igor Tandetnik A note to the original poster.

[sqlite] Re: Re: Re: how do i declare and use variables in sqlite?

Paul Harris <[EMAIL PROTECTED]> wrote: anyway, this is what i'm trying to do: eg 1 select @somevar := column1 from table1; update table2 set column2 = @somevar; update table2 set column2 = (select column1 from table1); Igor Tandetnik