Note also that by doing this, your database will be denormalised. This may
not be a big deal, however.
On Wednesday 03 April 2002 9:55 am, you wrote:
> UPDATE mytable SET field1=field2;
>
>
> -Original Message-
> From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03
update table
set newfield = oldfield
- Original Message -
From: "Chuck Barnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 6:10 PM
Subject: copying field x to field y for each record in table
> Hi, how do I do the following:
>
> I have a table I have a
Chuck,
Wednesday, April 03, 2002, 7:10:16 PM, you wrote:
CB> Hi, how do I do the following:
CB> I have a table I have added a new field to, I want to take field X and copy
CB> it to the new field for each record. What should this query look like?
UPDATE table_name SET y=x;
CB> Thanks,
CB> Chu
Am Mittwoch, 3. April 2002 18:10 schrieb Chuck Barnett:
> Hi, how do I do the following:
>
> I have a table I have added a new field to, I want to take field X and copy
> it to the new field for each record. What should this query look like?
>
UPDATE yourtable set newfield=x
Regards
Georg
---
At 10:10 -0600 4/3/02, Chuck Barnett wrote:
>Hi, how do I do the following:
>
>I have a table I have added a new field to, I want to take field X and copy
>it to the new field for each record. What should this query look like?
>
>Thanks,
>Chuck
UPDATE tbl_name SET y = x;
---
UPDATE mytable SET field1=field2;
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:10 AM
To: [EMAIL PROTECTED]
Subject: copying field x to field y for each record in table
Hi, how do I do the following:
I have a table I have added a
