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:
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
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;
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
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 Chuck
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 added a
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,