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 20:01:09
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
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, wiki
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 too
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 temporarily?
Hey chums you