: 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 new field to, I want to take field X and copy
> it to the new field for each
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:
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
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
-
Before posting, please check:
