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

[Igor Tandetnik]

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

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------