How about:
update table1 set beds1=(@TEMP:=beds1), beds1=beds2, [EMAIL PROTECTED]
Seems to work for me.
= original message follows ==
To: [EMAIL PROTECTED]
From: zzapper <[EMAIL PROTECTED]>
Subject: Re: A query to swap the data in two fields
Date: Thu, 23 Sep 2004
On Thu, 23 Sep 2004 13:31:03 -0500, wrote:
>At 10:04 AM 9/23/2004, you wrote:
>>On Thu, 23 Sep 2004 11:03:08 +0100, wrote:
>>
>> >Hi,
>> >
>> >I want to swap the data in two fields
>> >
>> >eg
>> > t1.beds to t1.beds2
>> >and
>> > t2.beds2 to t1.beds
>> > do I need to store one of the fields te
At 10:04 AM 9/23/2004, you wrote:
On Thu, 23 Sep 2004 11:03:08 +0100, wrote:
>Hi,
>
>I want to swap the data in two fields
>
>eg
> t1.beds to t1.beds2
>and
> t2.beds2 to t1.beds
> do I need to store one of the fields temporarily?
Hey chums you normally get me an answer in minutes, is my question
On Thu, 23 Sep 2004 11:03:08 +0100, wrote:
>Hi,
>
>I want to swap the data in two fields
>
>eg
> t1.beds to t1.beds2
>and
> t2.beds2 to t1.beds
> do I need to store one of the fields temporarily?
Hey chums you normally get me an answer in minutes, is my question too easy?
zzapper (vim, cygwin,
Hi,
I want to swap the data in two fields
eg
t1.beds to t1.beds2
and
t2.beds2 to t1.beds
Do i need to temporarily store one of the fields (thinking like a programmer)?
Can you suggest what query I need here pls?
zzapper (vim, cygwin, wiki & zsh)
--
vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyran
