Re: QUESTION: How to update some records with one value, others with another
From: joel garry <joel-garry_at_home.com>
Date: Thu, 10 Sep 2009 09:56:00 -0700 (PDT)
Message-ID: <5ae3d94a-a474-4c1d-8cd3-236e1fe3f116_at_i18g2000pro.googlegroups.com>
On Sep 9, 10:02 pm, JJ <sa..._at_temporaryinbox.com> wrote:
> Hi all,
>
> I have a list of user records that I need to update once to solve a
> problem with the application that uses the table.
>
> The records in this table have two fields: name and company.
>
> I need to update the company field with the existing company name in
> order to get it to appear in the application using the DB.
>
> Some of these have the company set to COMPANY X, others to COMPANY Y.
>
> The question I needed to ask is how can I accomplish updating the
> records once with the same company that they already have?
>
> For example, would below SQL code work:
> update user_records_table
> set company=company
Date: Thu, 10 Sep 2009 09:56:00 -0700 (PDT)
Message-ID: <5ae3d94a-a474-4c1d-8cd3-236e1fe3f116_at_i18g2000pro.googlegroups.com>
On Sep 9, 10:02 pm, JJ <sa..._at_temporaryinbox.com> wrote:
> Hi all,
>
> I have a list of user records that I need to update once to solve a
> problem with the application that uses the table.
>
> The records in this table have two fields: name and company.
>
> I need to update the company field with the existing company name in
> order to get it to appear in the application using the DB.
>
> Some of these have the company set to COMPANY X, others to COMPANY Y.
>
> The question I needed to ask is how can I accomplish updating the
> records once with the same company that they already have?
>
> For example, would below SQL code work:
> update user_records_table
> set company=company
Would you happen to know why it doesn't appear in the app? Did you disable an index or something?
jg
-- _at_home.com is bogus. http://favstar.fm/users/_whyReceived on Thu Sep 10 2009 - 11:56:00 CDT